That's why I suggested having a file for each month (rather than one
file for the whole year - do you know what 365 sheets in one file will
look like?)

You can group sheets together and then any changes you make to one can
be reflected in all the grouped sheets. For example, in the first
(monthly) file you create you could group sheets 2nd to 31st together
and in cell A1 you can enter this formula:

=IF(1st!A1="","",1st!A1)

Then ungroup the sheets by clicking on the tab for 1st, and you can
enter January in cell A1. Now all those other sheets will show January
in cell A1. When you come to save this file as February, all you need
to do is change the entry in A1 of the 1st sheet to February, then all
those other sheets will show that month.

Hope this helps.

Pete

On Jan 8, 4:07*pm, kayak99 wrote:
Pete, *

That does give a months worth of spreadsheets but it appears I have to go
back and manually rename the tabs as well as change the dates on each sheet.

It was those two manual changes that I was trying to avoid beacuse I want to
chart an entire year. *That's a lot of renaming - two each day (tab date and
cell date). *

Just to review if I didn't state my needs correctly, same spreadsheet,
different dates, one for each day of the year.

Maybe there is no way to accomplish this other than your manual suggestion.