Pasting data into a column that moves each month

[Joe123]

Hi

I want to write some code that lets me Paste a column of formulas into another column. The column I am pasting to moves one position to the right each month. For example this month the formulas need to be pasted to column d, then next month the formulas need to be pasted to column e

Thanks

 

[jc.021286]

Change the formulas to utilize the Offset formula. That way you can offset it by 1 every month.

Offset(A1,0,1) + Offset(A1,0,1)

Or
Offset(A1,0,Column(A1))+Offset(A1,0,Column(A1))

jc

 

[Jonmo1]

Would it be fair to say you are just pasting into the first available(empty) column?

Try

Range(copyrange).Copy Destination:= Cells(1, Columns.Count).End(xltoleft).Offset(0,1)