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.