Hi there,
So, I receive a schedule of meetings each month which could range from 30 to 100 rows.
Within my demo spreadsheet, this sheet is called "Schedule" with the one training session across the columns.
I need to create attendance sheets for each row on Schedule sheet.
I want to copy the "SignSheet" move data from "Schedule" from each row to the new "SignSheet" to each yellow highlighted areas, name the sheet and move to the next row.
Since I cannot have duplicate sheet names, I added column A with each sheet number to be used as sheet name.
Once all sheets are made, I would like to print out all sheets all formatted as the original "SignSheet"
I will then need to have a way to delete the previous month's sheets ready for the new month to begin the process again.
I have googled some but I have not found any code that works close to what I want.
Thanks
Bookmarks