Move formulas to another column then preserve values in 1st column

[malanis]

Every month I need to move the formulas over to the next column, then preserve the numbers that I took the formulas from. Here is what I will do this month:

Highlight CJ4 to about CJ100, copy, select CL4, paste. Select CJ4, paste special, values only.

How can I do this with a macro? Sometimes, like between Dec and Jan, there will be a quarter total column.

Thanks!

[xladept]

Hi Malanis,

Try this:

Please Login or Register  to view this content.

Copy the code to the clipboard
Press ALT + F11 to open the Visual Basic Editor.
Select Module from the Insert menu
Type "Option Explicit" then paste the code into the white space on the right.

With the cursor between Sub and End Sub press F5 OR

Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macroname (Malanis)