Sorting Grouped Data?

Hi,

I have a sales spreadsheet that is grouped by vendor with customer sales
info under each vendor. Is there a way to sort the vendor groups
keeping the customer data in each groups as is?

TIA,
Dan

This may work Dan.

To sort in Excel all the lines need to have same columns to sort on. So
a heading line and a space between Vendor Groups would be be a problem

You could add 2 columns (In the Example below columns A and B) with sort
data criteria so that the Heading and Space positions could be preserved.

Column A defines the Vendor Group
Column B defines the sort priority

Then Sort by Column A / B / C
Don't print Columns A and B

A B C
1 Vendor1Code A Vendor 1 Group Heading
2 Vendor1Code B Vendor X 1
3 Vendor1Code B Vendor X 2
4 Vendor1Code C (Blank Line)
5 Vendor2Code A Vendor 2 Group Heading
6 Vendor2Code B Vendor Y 1
7 Vendor2Code B Vendor Y 2
8 Vendor2Code C (Blank Line)



Bernie Simmonds



Dan wrote:

> Hi,
>
> I have a sales spreadsheet that is grouped by vendor with customer sales
> info under each vendor. Is there a way to sort the vendor groups
> keeping the customer data in each groups as is?
>
> TIA,
> Dan

It kinda-sorta depends on why you want the sorts, and what else you might
want to do with them..........I think either the Data > Filter >
AutoFilter...........or the Data > SubTotals features might be of interest
to you............

Vaya con Dios,
Chuck, CABGx3




"Dan" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a sales spreadsheet that is grouped by vendor with customer sales
> info under each vendor. Is there a way to sort the vendor groups
> keeping the customer data in each groups as is?
>
> TIA,
> Dan