View Single Post
  #1   Report Post  
Ken
 
Posts: n/a
Default Copy worksheets and formats

Hi,

I have a worksheet (budget) set up as 31 columns representing days of a
month. I also have a worksheet designated as yearly, 12 columns for each
month. The first worksheet, Jan, totals numerous rows and sends the data to
the Jan column of the monthly WS. I need to copy the Jan worksheet in a way
it will change the Jan! to Feb!, then Mar!, etc. If I copy it as is the data
will be the same as the month of Jan. Hope you can understand this. I can't
;+)

Ken