Code to copy every nth cell in column c and paste in every nth row range

[ellie2014]

Hi,

I need help in creating a code that will copy every 39th cell starting with C3 in column C and paste to D:AG for every 39th row until there are no more values to copy in column C. For example If I have value 752111 in C3 I want it to be copied into D8:AG8. I need for this to happen for the next value in C41 and have that pasted into D46:AG46 and so forth until there are no more values to copy in column C.

I hope this makes sense but if you need me to elaborate, please let me know thank you!

[spitfireblue]

Hi Ellie,

I think this is what you are after...

Please Login or Register  to view this content.

[ellie2014]

Thanks Stephen! This works perfectly.

[spitfireblue]

No problems, anytime