need to get several formulas to change chronologically across shee
 

I have a macro which creates a months worth of logs from four templates. It
works well to create the month based on whatmonth and whatyear. I am now
having trouble trying to get some cells to have the formulas needed created
as the macro is running. For example I have worksheets named Jun-1 through
Jun-30 in these worksheets cell b33 needs to equal the previous days entry of
the cell above(cell b33='Jun-1'!b32') and follow this chronologically
throughout the workbook. Does anyone have any help on how I can write the
code in visual basic to make this happen? Any and all help is appreciated.

need to get several formulas to change chronologically across shee
 

You should ALWAYS post your coding efforts for comments. But this is the
idea

for i=1 to 30
cells(i,"b")=cells(i-1,"b")
next i

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Paolo" wrote in message
...
I have a macro which creates a months worth of logs from four templates. It
works well to create the month based on whatmonth and whatyear. I am now
having trouble trying to get some cells to have the formulas needed
created
as the macro is running. For example I have worksheets named Jun-1 through
Jun-30 in these worksheets cell b33 needs to equal the previous days entry
of
the cell above(cell b33='Jun-1'!b32') and follow this chronologically
throughout the workbook. Does anyone have any help on how I can write the
code in visual basic to make this happen? Any and all help is appreciated.