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.