You might want to try using a pivot table. Deb Dagleish has a lot of
examples at http://www.contextures.com/tiptech.html. However, if you really
only want to get the subtotals, run the Subtotals, hit the 2 to display only
the subtotals. Select the range of cells. Hit Edit--Go to--Special and
choose Visible cells only. Copy and paste to another worksheet.
*******************
~Anne Troy

www.OfficeArticles.com


"itchy777" wrote in message
...
How can I separate sub-totaled data from the detail it was created from.
For
example, if I want to sort the sub-totaled data, the detail is included in
the sort.

I have similar problems when trying to do other things with sub-totaled
data
when I don't want to include the detail.