Forum Discussion
Need help for a macro for a copy-paste and skipp
HI everyone!
I need you help to write a macro (I'm sure it's pretty simple but I can't manage...).
On my Sheet 1 I have a list.
I need to copy past that list but only every other cell on my sheet two. (you'll see in the document, it's pretty self explanatory).
For instance, in C1 I want to copy 'Sheet 1'!D1
In H2, 'Sheet 1'!D2
In C18, 'Sheet 1'!D3
Ect
(again, look at the exemple, it makes so much more sense that way).
I need to do this for a great number of cells which can take a lifetime. So I'm looking for a macro to do that for me.
What I can't seem to do is to automate this and make it stop (so that it doesn't run indefinetely) at a certain point (basically, when my list is over).
The list that you'll find in the file is just an exemple, it would actually be names or places, sometimes numbers.
Thank you so much for your help!