How to make copies of a spreadsheet, within a book, where the dates change automatically

Assume:
A2 = Date { Nothing magical about this location}
A38 = Convert Date to Text in Cell A38 =TEXT(A2,"mm-yy"){ Nothing magical about this location}

Macro:

Please Login or Register  to view this content.

Change cell references as appropriate

- You input the Tab name somewhere on the sheet. I choose A2.
- Since the spreadsheet can not use a date, it has to be converted to text. I chose cell A38
- The macro reads the text from Cell A38 and changes the tab name to match

To make it fancier, Excel could read the previous spreadsheet and change the tab name dynamically but that is for a different question

I made a couple of changes to your spreadsheet. Look at Tab 12-12
Notes:
A38 = Date
A39 = Date converted to text
A3 = Month based on what you put in in cell A38
A4 = Year based on what you put in in cell A38

The macro to set the Tab looks at cell A39 to changes accordingly.
You need to change the formulas in cells A3, A4, A38 and A39 in the other tabs. I could not change them as those tabs appear to be password protected

If you move cell A39, you need to edit the macro.

I highlighted the changed cells in yellow

Note this is now a macro-enabled spreadsheet

I was able to edit the tabs and changed all accordingly.

Notes:
- In cell A38 of each sheet, enter the date for the tab ie 8-1-12. I formatted it in
white font so it won't print
- Cells A3 and A4 are changed accordingly.
- Run the macro, the tab will be changed according to what is in cell A39 - also in white font.
Cell A39 in the text equivalent of cell A38