View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RS
 
Posts: n/a
Default 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.