+ Reply to Thread
Results 1 to 3 of 3

Autopopulate sheets within one workbook based on condition...

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    Oregon
    MS-Off Ver
    Excel 2003
    Posts
    1

    Autopopulate sheets within one workbook based on condition...

    Hello!

    I have a single registration sheet that lists names, contact information, and the class someone is in on a single sheet.
    (Name, Number, Email, Class 1, Class 2)

    I am hoping to automatically populate other sheets in my work book based on classes... essentially making automatically populated rosters. For example, everyone who has Math listed in either Class 1 or Class 2 would have their entire row (with contact information, etc) copied to the "Math" sheet.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Autopopulate sheets within one workbook based on condition...

    Math work sheet:

    A2: =IFERROR(INDEX(Registration!A:A,SMALL(IF(Registration!$C$2:$D$5="Math",ROW(Registration!A$2:A$5)),ROW($A1))),"")

    Ctrl+Shift+Enter, not just Enter
    Copy down and across. Do the same other work sheets just change "Math" to "your desire criteria"

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Autopopulate sheets within one workbook based on condition...

    hi Anm, welcome to the forum. try this non-array formula that will work for all worksheets:
    Please Login or Register  to view this content.
    but do note about the consistency of the names. for eg. "English " in C2 has an extra space. so does "Science" in C4 & "Math " in C5. "History" it seems, is not accepted as a Sheet name, so you got to use a word that's the same in "Registration" & the sheet name

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1