Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a Blank Line with Change in Name
I have a list of contacts thousands of rows long. I have sorted the list by
contact and each contact name can make up more than two rows and up to ten. I need to add a blank line for every change in contact name in the column to make the worksheet easier to read. The macros I tried to develop only has a set place to add a row but I would like it to work similar to a subtotal statement. In a subtotal statement, you can ask for a total at every change in a certain column. For every change in the column I would like to add a blank row. Is this possible? I appreciate any assistance with this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change line spacing for text box in excel chart | Charts and Charting in Excel | |||
Blank line in cells | Excel Discussion (Misc queries) | |||
How do I use VBA to change line colors | Charts and Charting in Excel | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Adding a text label to a line. | Charts and Charting in Excel |