M
mlv
Hi
I have a yearly workbook with 12 sheets, one per month.
Each sheet has a header cell (assume A1) that shows the month and year for
that specific sheet.
Assuming I manually enter (for example) 'April 2007' in the month/year cell
of sheet 1 - how easy is it to arrange for sheets 2 to 12 to populate their
equivalent cells with successive months and the year, thus:
Sheet 1 : April 2007 (entered manually)
Sheet 2 : May 2007
Sheet 3 : June 2007
etc, etc...
Sheet 9 : December 2007
Sheet 10 : January 2008 (Note year increment)
Sheet 11 : February 2008
Sheet 12 : March 2008
Please note that the month/year manually entered in sheet 1, cell A1, may
bear no relationship to the current year or date and could be any month of
any year from 2000 onwards.
I would format Cell A1 as either 'General' or 'Text' as I don't want any
Excel date functions interfering with my input.
Thanks
I have a yearly workbook with 12 sheets, one per month.
Each sheet has a header cell (assume A1) that shows the month and year for
that specific sheet.
Assuming I manually enter (for example) 'April 2007' in the month/year cell
of sheet 1 - how easy is it to arrange for sheets 2 to 12 to populate their
equivalent cells with successive months and the year, thus:
Sheet 1 : April 2007 (entered manually)
Sheet 2 : May 2007
Sheet 3 : June 2007
etc, etc...
Sheet 9 : December 2007
Sheet 10 : January 2008 (Note year increment)
Sheet 11 : February 2008
Sheet 12 : March 2008
Please note that the month/year manually entered in sheet 1, cell A1, may
bear no relationship to the current year or date and could be any month of
any year from 2000 onwards.
I would format Cell A1 as either 'General' or 'Text' as I don't want any
Excel date functions interfering with my input.
Thanks