Yes, the tab name is based on the date. Whereas the date displays in the
spreadsheet as 01/01/06 and then on word within the other spreadsheets by
adding one to the previous spreadsheet, it displays as 01-01-06 and so forth
in the tabs.

"Gary''s Student" wrote:

Is the tab name in any way based upon the date in A1? Remember that a tab
name cannot have a / in it.
--
Gary''s Student


"Chris" wrote:

I have a large workbook (150 sheets). In Sheet 1, Cell A1, I have the first
date (example: 01/01/06). I have Sheet 2, Cell A1 set to take the result of
Sheet 1, Cell A1 and add 1 to it to get 01/02/06, Sheet 3 adds 1 to sheet 2's
to get 01/03/06 and so on.

How can I set up the sheet tabs to automatically rename themselves when I
change the date in Sheet 1, Cell A1. I want it to change all the tabs
without having to go into each one and pressing enter or double-clicking them
to make the tabs change.