group rows between blank rows

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.
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top