Macro to Copy down and insert line continously

[exc1967]

I have a spreadsheet that I need to copy row 1, insert a line in row 2 and paste the contents from row 1. Then I need it to copy row 3, insert a line and paste it in row 4. I will need to do this continually, until there are no lines left.

[arlu1201]

I guess it will be better understood if you attach a sample file.

[exc1967]

Here is a sample file. I have already copied the row 1 and row 2, now I need it to continue on and copy row 5 and insert a line in row 6 and paste the contents from row 5 into row 6. Then it would copy row 7 and insert a row into row 8 and paste those cells.

[JBeaucaire]

Fastest way... since there is a UNIQUE value in column N....

1) Copy all the data at once, paste below the original data at row 20
2) Highlight all the data
3) Sort the data by column N



Here's a macro version of that:

Please Login or Register  to view this content.