Copy each cell in range and paste 12 times

[Groovicles]

Hi everyone,

I need some help with a small macro. In Sheet1 range A1:A20 each cell has a value. What I want to do is copy each cell in A1:A20 into column B (starting at B1) and repeat the past 12 times. So cell A1 will be copied to B1 and then copied down another 11 times. Cell A2 will be copied to the next available cell in column B and copied down 11 times, etc.

Any ideas?

Thanks!!

[davsth]

Please Login or Register  to view this content.

[davsth]

index(a$1:a$20, int(row(a12)/12)) would also work as a formula in b1 copied down

[davsth]

if you are happy with the solution, you should mark the post as solved. thank you for the rep