Hi
Reduce the grouping to show just the information you want. Hit F5 and select
Visible Cells.
Ctrl+C to copy. Move to where you want the totals and click Edit / Paste
Special / Values.

--
Andy.


"Homer" wrote in message
...
Hi

I want to copy the subtotals only from one sheet to another, there must be
a
way??

Thanks

Homer "D'oh"