Debra Dalgleish wrote:
Collapse the subtotals, so only the Company Names, and subtotal amounts
are visible. To do this, you should be able to click the 2 button in the
Outline bar.

Select a cell that contains a subtotal
Click the Z-A button on the toolbar

If you want to copy just the subtotals to a new area of the workbook:

Select the cells that you want to copy
Choose EditGo To
Click the Special button
Select Visible cells only
Click OK

Click the Copy button
Select the cell where you want to start the paste
Click the Paste button.


gls858 wrote:

I have a spreadsheet with three col. Company, Date, Invoice Amount
I sort by Company and subtotal invoice amount to get the YTD
total for each Company. What I would like to do is sort the subtotaled
amounts in descending order. What's the easiest way to do this?

I tried a copy and Paste Special values but it copied the
underlying detail also.

gls858



Thanks Debra. Doesn't get any easier than that :-)
I was highlighting BOTH col and it wouldn't sort.
Never thought about selecting just the subtotal col.
I usually work with detail without subtotals so I'm
used to selecting all cols. to sort.

gls858