how do i do this?

G

GeneralNuisance

col a (a7:a64) contains dates for the current month with data in
subsequent columns

data is pretty static (repetitious) from month to month

at the end of each month i copy the current w/s to a new w/s (not w/b)
is there an easy way just to change just the month in column a

1/15/06 becomes 2/15/06

thanks
 
C

CLR

In the top cell of your DATE column, type in the first date of the range of
interest, such as 1/1/2005...........then, assuming that is in cell A5, in
the cell just below it, put =A5+1, and copy the formula down as far as you
want. Then, whenever you change the date in A5, the other cells will
automatically follow..........

hth
Vaya con Dios,
Chuck, CABGx3
 
Top