Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
group rows between blank rows
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
group rows between blank rows
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. "renee" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions |