group rows between blank rows

  • Thread starter Thread starter renee
  • Start date Start date
R

renee

I have a spreadsheet with customer information listed in under the column
heading customer. I need to sort by another column, but I need to keep the
customer name, address and phone number together. I have been grouping the
customer information and sorting it by the other column. This works, but I
have thousands of rows. The rows that need to be grouped are preceeded and
followed by one blank row.
 
You need to put an ID number on the all the rows for the same customer so you
can keep the customer info together. I can write a macro to add an id to
each customer if I had more info on your worksheet.
 
Back
Top