Creating rosters automatically from list of entire school

[kristinbrew]

Hi all! After getting some help with my attendance/student info spreadsheet, I'm getting crazy ideas. Excel is magical.

Anyway, here's what I'd like: I have a spreadsheet with every student in the school listed. If they have signed up for my after school programs, they also have a 3-day schedule. Each program has a specific initial, so if a student is in 1st grade Art on Monday, they have a "1A" in the Monday column. I've attached a sample spreadsheet with a simplified version of my setup.

At this point, I'm filtering by each initial and highlighting names to print a roster for the day. Is there a way to have the names of each child in a particular program automatically populate an (easy to print) formatted roster on another tab? Each student does have a unique student ID if that helps, but I wouldn't want that private info to be printed on the roster. I'd like to just be able to enter kids' schedules as they come in and that automatically adds to the program's roster, then go to the "Monday Rosters" tab and print the whole thing, cut it up, and hand out to teachers.

Any ideas you can give would be WONDERFUL.
THANK YOU!
Kristin

Rosters sample.xls

[Pauleyb]

My immediate thought is to use Mail Merge with Word and the spreadsheet as an input.

Tons of links out there with a google search, but here is one:
http://www.internet4classrooms.com/m...mletter_07.htm