Cell Change Triggers Copy Range, Paste to next column, Repeat

[JonesyUK]

Hi Folks, I could really use some VBA help please:

Worksheet Name: "Calculation"
"Range" = C1:C40

When Cell C2 on this sheet changes in any way, then I need VBA to copy the "Range" and paste the values to Column D ("D1:D40"), then with each new change of cell C2, copy ("Range") to the next column, E, then F, etc. ending at column "BT", i.e. repeat this process 69 times in total.

Hope this makes sense, I appreciate any input on this.

Any ideas please?
Thanks!

 

[vcoolio]

Hello Jonesy,

No idea why. I've just tested it on my end a number of times and it works just fine. As you can see in the code, the column increment is 1.
Did you place the code into the "Calculation" sheet module? Is your formula in C2 of the "Calculation" sheet referring to just the C2 value on Sheet1?

Cheerio,
vcoolio.