I have a worksheet that displays cash flows in 60 columns of a row Rrepesenting 60 months).

Depending on the input of another cell "X1" (containing possible a range 0 to 12) I want all 60 cashflows to move to the right by the value (from 0 to 12, 0 representing stay as is).

i.e. if value x1 = 6 value in cell "A1" is now in "A7", "A2 is in "A8" etc

Is there an easy way to code this??

Appreciate any ideas,

Cheers

Peter