Hi there
I have an issue with a macro that I’m hoping for some help with.
The first step is pretty simple I would like for the macro to firstly copy the formula found in the range A1:A5 to B1:B5. Then I would like to copy/paste the values of range A1:A5 to A1:A5.
The trick is now that the next time I run the macro I want the macro to copy the formulas in the range B1:B5 to C1:C5 and then paste the values of range B1:B5 to B1:B5. Third time should it should then copy column C to D and so forth.
Hope someone will be able to help me out.
As always any help is very much appreciated
I have an issue with a macro that I’m hoping for some help with.
The first step is pretty simple I would like for the macro to firstly copy the formula found in the range A1:A5 to B1:B5. Then I would like to copy/paste the values of range A1:A5 to A1:A5.
The trick is now that the next time I run the macro I want the macro to copy the formulas in the range B1:B5 to C1:C5 and then paste the values of range B1:B5 to B1:B5. Third time should it should then copy column C to D and so forth.
Hope someone will be able to help me out.
As always any help is very much appreciated