I am a teacher and every week I run a report that shows students who are performing poorly. I take that list and assign students to specific teachers for a study hall. Some students will have more than one teacher in a week and teachers will have varying lists of students each day. What I am wanting to do is to setup a tab for each teacher to have their assigned students for the week listed by day so they can check attendance. I would like this list to be automatically populated from my report spreadsheet. I have attached an example of what I am looking to do.
Sheet 1 - Assigned: This would be the list of student who are doing poorly and what teacher they are assigned to each day.
Sheet 2-4 - Teacher #: These are the individual sheets that I am wanting to populate from the ASSIGNED sheet. The teachers name and days are one
each sheet for formula reference. (If I could figure the formula out.)
Sheet 5-7 - RESULTS Teacher #: These are examples of what I would expect the final product to look like when I am finished.
Thank you in advance for your assistance.
Jeff
Bookmarks