Macro code to copy formula in previous month to the current month.

[Marnelli]

hi need a macro code to copy a formula from previous month and paste it on current month. after that, need to paste as values the previous month's data. The months are in column. thanks in advance!

[SamT]

Start recording a macro. Do what you need to do manually. Stop recording the macro.

show us the Macro code.