Collapse the groups and select all the subtotals.
Hit <F5
Click on "Special"
Click on "Visible Cells Only"
Then <OK

Right click in the selection and choose "Copy"

Then navigate to wherever you wish, and then "Paste".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Diane" wrote in message
...
I have a worksheet with subtotals, but I'd like to take just those
subtotals
to another sheet for further manipulation. Any ideas?

Thanks,
Diane