Copy and paste values of specific column and increase a cell value by 1

Hi all,

I'm looking to setup a macro that will copy a column's values and then paste them in the same column as values rather than a simple copy paste. after the pasting it will also need to increase a certain cell value by 1.

using the attached file as an example. I'm looking to have the macro copy and paste the values from the range I8:I23 back into the same range so that the formulas are removed but the values stay "written" in. also, the macro will need to increase the cell B3 value by 1.

The idea is that this macro will essentiall roll forward the sheet to show the next financial month, but keeping the previous months values allowing me to compare changes in cost forecasts, budget changes etc).

I hope this is enough to get started with, if not I can provide more info if needed.

Hi there,

just copy/paste this in your ThisWorkook object (or a module of your workbook)

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

This will increase to the next month everytime the macro is run.

Please Login or Register  to view this content.