Adding 2 Rows at a time in list

[JimmiOO]

Can anyone help me with this, i have a list A1 - A2000, I want to insert 2 Rows between each row in my list. Is their a quick way to do this?

[Richard Buttrey]

Hi,
One way...

Please Login or Register  to view this content.

HTH

[JimmiOO]

Hi Richard

I have tried to get that to work but can't seem to do it, I have added a sample.

[oldchippy]

Hi,

Richards code works fine, take a look here

http://www.excelguru.ca/node/5

[Ruthki]

If you want a relatively quick non VB method.

Insert column (or use end column), number each row (autofill), copy all numbers twice below data. eg:

1 data
2 data
3 data
4 data
1
2
3
4
1
2
3
4
Then sort by column with numbers in, with second sort on any column with data in. Delete colum with numbers in.

R

[Richard Buttrey]

Hi,

I can't see where you have added the VBA code I gave you.

Of course one non macro way would be to put the numbers 3,6,9,12...etc in column B alongside your existing numbers, then starting in the row after your last number, in column B add the numbers 1,2,4,5,7,8,10,11,...etc for another 4000 rows, then just sort the two columns using column B as the key. This will probably be quicker than a macro.

Rgds

[JimmiOO]

Thanks Richard sussed it now

[oldchippy]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save