Add row between current rows in a way to long sheet....

[Mari-Ann]

I need to add 1 row between each current row in an 2670 rows long excelsheet.
And yes I am lazy, so could anyone help me create the macro? Seems I'm doing
something wrong...

PS: I'm working excel 2003.

Thank you for your help!

 

[Pete_UK]

Just fill a simple sequence 1, 2, 3, ... 2670 in a blank column next
to your data (imagine this is column H). Then copy that sequence down
to H2671 and down. Then highlight the block of data (including the
helper column) down to row 5340 and perform your sort, using column H
as the sort key. You can delete column H afterwards.

Hope this helps.

Pete

 

[Mari-Ann]

Offcourse!!! Why did I not think of that...

Super!!! THANK YOU for your help!

 

[Gord Dibben]

Why do you need to add a row between each current row?

This would make the sheet very hard to sort or filter.

If just for appearance, simply double the height on each existing row.


Gord Dibben MS Excel MVP

 

[Pete_UK]

You're welcome, Mari-Ann - thanks for feeding back.

Bear in mind Gord's comments, though, as this will make the sheet very
awkward to work with.

Pete

 

[Bob Umlas]

What? Without credit to my book, tip # 68 in blue book (or #56 in red
book)??
Shame!



Just fill a simple sequence 1, 2, 3, ... 2670 in a blank column next
to your data (imagine this is column H). Then copy that sequence down
to H2671 and down. Then highlight the block of data (including the
helper column) down to row 5340 and perform your sort, using column H
as the sort key. You can delete column H afterwards.

Hope this helps.

Pete

 

[Pete_UK]

Hi Bob,

I don't have either of the books you refer to, so I can hardly give
you credit !!

Besides, I remember doing something like this with View Professional
on a BBC Master in the 1990's, so I think the method has been around a
number of years.

If you would like to send me complementary copies of your books then I
will see that you get proper accreditation in future <vbg>

Pete