Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a file with a listing of entries, and in column B of all the entries,
are unique names. I need to create the code to reference the listing, which at times will be 200 entries and other times 1000 entries, and evaluate the data in column B, to then insert 2 blank rows every time a different name appears. For instance Initially column B has (Row 1) Pears (2) Pears (3) Pears (4) Apples (5) Grapes (6) Grapes After the desired code, the results would be.. (Row 1) Pears (2) Pears (3) Pears (4) Blank Row (5) Blank Row (6) Apples (7) Blank Row (8) Blank Row (9) Grapes (10) Grapes END OF FILE Any and all help will be appreciated - Thank You In Advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text to Rows and then Insert Blank Rows | Excel Discussion (Misc queries) | |||
How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
insert blank rows | Excel Discussion (Misc queries) | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
Macro code to test for blank row and insert blank row if false | Excel Programming |