I have subtotals in a worksheet and would like to now organize the worksheet
so that the subtotalled data is in greatest to lowest or lowest to greatest
order. But I want not only the subtotal data to show but also the
individuals rows that make up the data. See below:

Kerry Smith 9/1/07 Inv 712 $200.00
Kerry Smith 10/1/07 Inv 740 $200.00
Kerry Smith 11/1/07 Inv 760 $200.00
Kerry Smith 12/1/07 Inv 780 $200.00
Kerry Smith $800.00
Joe Aimes 10/1/08 Inv 900 $300.00
Joe Aimes 10/1/08 Inv 900 $300.00
Joe Aimes $600.00
Bill Jones 1/1/07 Inv 670 $200.00
Bill Jones $200.00

Any help would be much appreciated.

Thank you,

CC