J
JHC
I need to do a sheet for each month with the month in words on each sheet and
the date in figures. Starting with January 2008 I have copied the sheet for
each subsequent month using the edit menu then have to manually change the
date each time. ( I have to do this around 200 times!)
Is there a way to get each copy to automatically change to the next month
when it is copied? For instance with a formula? The date in figures is always
the same day and year - just the month changes each time.
Version of Excel is Office 2003.
the date in figures. Starting with January 2008 I have copied the sheet for
each subsequent month using the edit menu then have to manually change the
date each time. ( I have to do this around 200 times!)
Is there a way to get each copy to automatically change to the next month
when it is copied? For instance with a formula? The date in figures is always
the same day and year - just the month changes each time.
Version of Excel is Office 2003.