Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Blank Rows
I have all my clients sorted in a sheet with column A containing month 1, 2,
3, 4, up to 12 - then column B has the client code, column C client Surname and Name. I need to insert 2 rows after each client and need a code to be able to do this as there are over 500 clients. I have filtered to show unique on column B, and to do a simple keystroke is DOWN, DOWN, DOWN, INSERT ROW, INSERT ROW. The problem is that some clients started and ended at various times during the year, so not all have the same number of entries. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert blank rows | Excel Discussion (Misc queries) | |||
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) |