Hello! I run an after-school program that students register for in order to participate. I've created macros to help assign classes, but once they are assigned, I would like to run a macro that takes information from the master schedule and generates individual schedules for each student that I can print our and send home.
In the attached spreadsheet are two tabs: one is the master schedule ("SUN Student Class Schedule"), and the other is a template of the format I'd like the individual schedules to take. The individual schedules contain student name, teacher, classes, and mode of transportation.
My idea was to run a macro that creates a new individual schedule (either in the Template tab or in a new tab), and then copy/pastes the data from each row in the master schedule to the newly created schedule.
I can create a macro to do it once, but can't figure out how to replicate that macro for every single row without doing it myself first.
I have also though of creating many empty individual schedules and having the display cells reference each unique row, but again can't figure out how to do it without typing in each function. If I were to create a template individual schedule and copy/paste, the fill-out function would skip many rows on the master schedule.
Any ideas and suggestions are greatly appreciated! Thank you very much for your help.
Everett
Bookmarks