Split Schedule into separate sheets

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

Please try

Please Login or Register  to view this content.

Hello ikboy,

Thanks for your solution to my question, it did work as requested, but it ended up deleting the first two sheets which was the sheets I wanted to keep.

Hello BO_RY,

Thanks for your solution to my question, it did work as requested. I tried it on my real data and I am very happy with the results.
It's good to see how others approach coding this, I have lots to learn!!
Thanks