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.
--
JHC

You should have the Month and Date in the figures set as a formula. to get
the formula in the figure you must select the figure then type the frormula
in the formula bar at the top of the worksheet.

the formula can contain be something lik this

=A1 & "is this month" where A1 contains January

"JHC" wrote:

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.
--
JHC

Thanks - I have the date as a field and want to advance it by one month on
each subsequent sheet - is that possible?
--
JHC


"JHC" wrote:

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.
--
JHC

Something like this should work

On sheet 2
=DATE(2008,MONTH(Sheet1!A1)+1,1)

"JHC" wrote:

Thanks - I have the date as a field and want to advance it by one month on
each subsequent sheet - is that possible?
--
JHC


"JHC" wrote:

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.
--
JHC