Autopopulate sheets within one workbook based on condition...

**anm** · 12-20-2012, 09:35 PM

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.

**Teethless mama** · 12-20-2012, 10:56 PM

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"

**benishiryo** · 12-20-2012, 11:48 PM

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