need to get several formulas to change chronologically across shee

[Paolo]

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.

 

[Don Guillett]

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