Changing worksheets to the next years dates
 

I have a full year by month worksheet where we enter daily tabulations. Is
there a way to change the dates from this years 2008 dates to continue on to
the 2009 calender year. Otherwise I have to rebuilder 2009, cut and paste.
--
R Heitzman

Changing worksheets to the next years dates
 

Editreplace20082009

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"R Heitzman" wrote in message
...
I have a full year by month worksheet where we enter daily tabulations. Is
there a way to change the dates from this years 2008 dates to continue on
to
the 2009 calender year. Otherwise I have to rebuilder 2009, cut and paste.
--
R Heitzman

Changing worksheets to the next years dates
 

Select last date. Right click.Drag over area for new dates and release
button.Select fill seriese 'Fill Month'.
--
Clifford Roy


"Don Guillett" wrote:

Editreplace20082009

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"R Heitzman" wrote in message
...
I have a full year by month worksheet where we enter daily tabulations. Is
there a way to change the dates from this years 2008 dates to continue on
to
the 2009 calender year. Otherwise I have to rebuilder 2009, cut and paste.
--
R Heitzman