need to get several formulas to change chronologically across shee

  • Thread starter Thread starter Paolo
  • Start date Start date
P

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.
 
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
 
Back
Top