Generating multi[ple worksheets from a single master worksheet

**zenadiani** · 11-21-2010, 02:43 PM

I have a master attendance worksheet with instructor names and their students. I would to separate/create worksheets for each instructor with their student attendances. In addition, I would like to student attendance of each instructor to show up in the master attendance worksheet. So far, I have used the following formula:
=IF(ISNA(VLOOKUP($A$1,MASTERLIST!$A$3:$C$11,2,FALSE)),FALSE,VLOOKUP($A$1,MASTERLIST!$A$3:$C$11,2,FALSE))
All I get is the first matching student for the instructor but not the rest of them. Any help will be mightily appreciated.

**mrice** · 11-21-2010, 02:54 PM

I suggest that you post a copy of the master worksheet so that you can be helped further. It is difficult to understand the problem when the layout of the data is missing.