Forum Discussion
Rename multiple sheets in Excel workbook
I have a sheet for each day of the year and I make 3 quarterly workbooks. I want to change the date for each sheet (tab) made without clicking and renaming them all. I tried to do a VBA code but fa...
Do you want to make a new workbook, and then add 90 (?) worksheets and have them all dates? Or just create a new worksheet each day and have a button that renames it for you?
I would to have workbook with running dates
Eg 20 Saturday August 2018
Before month calendar after month calendar
Who is rostered on for Saturday or on call
21sunday August 2018
The calendars
Who is rostered
So I can print off cut on stick into old dairy with out wasting paper.