I have attached a copy of what I am trying to do, but I'll also explain it in words here.
I have information on a Worksheet called 'Schedule' in two columns.
I have a Worksheet called 'Template' that I want to copy to new Worksheets, rename those Worksheets, and fill in data from 'Schedule' when I click on a button.
Additionally, once I have the new Worksheets created, I want to populate a 'Master Calendar' Worksheet that looks across all other Worksheets and puts the data in chronological order.
I have attached an example. The data source is the 'Schedule'.
Thanks in advance for any help. I am an extreme novice so any help is appreciated.
Excel Help.xlsx
Bookmarks