Creating a Teacher Schedule With Lists of Students based on student schedules

Can you include a sample workbook WITH data I can see flowing through the model?
I dont see the teachers names, or how you identify who goes where... but I would suspect you can do ALL of this with a pivot table (AND NO FORMULAS!) since your Students tab is standardized (except for the crazy freshman-senior column lol).

Post a sample workbook that includes FAKE data and a fake example or two of the reports you are trying to create. Make sure it has all the data in it, like names, class, teacher name or whatever you want to have so its a CLEAR representation of what you are trying to accomplish and I bet I can help you with a simple solution.

EDIT: double post, somehow

Correct.

Sample Data and sample proposed solution.

you dont have a list of teachers in the main data, so I have no idea who goes where or why.

I've looked at this a few times.... and FINALLY, I understand what you're after.... I shared MikeTron's confusion.

One thing. Do you want the search to go to the bottom of the list (i.e. row 309) or just to the bottom of the freshmen. I've set it only for freshmen. If that's wrong, simpluy adjust the ranges. I've only done this for two teachers (Davis & J. Hill). I daresay you can do the rest.

Drag the formula right & down.

Any problems, shout...

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

Originally Posted by ked2313

Sorry for the confusion! mikeTRON, The teacher's names are the titles of the other sheets. Thank you so much for the Formula Mr. Kennedy!

Yeah, my intention was to get them all in simple data, and then use a vlookup or powerpivot to marry the two datasets together, so then EVERYTHING is a pivot table

It took me a while to realise that the teacher's names weren't important. The class names define/are unique to the teacher (I hope.... or I've given the wrong solution).