With your existing data in sheet1, Sub-totaled (level2-being currentlyselected)
I Highlight the full range - Edit, Goto, Special Cells button...
Visible-Cells Only select
then Copy
then go to or add sheet2 (Should be Blank)
and Paste
Then on sheet2 Datat, Sort., Cost << Desending
Your Sheet1 data is INTACT
HTH

"dnamertz" wrote:

I have a few thousand row of part numbers with their costs (many part numbers
appear on multiple rows) and I have sorted them by part number, then I
subtotalled the cost column. Now I want to sort them by the subtotal amount,
so the part number group with the highest cost subtotal is first, but I want
to keep the detail in tact. How do I do this?