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.


"Webs" wrote in message
...
When using excel sub total function. How do I copy the sub total to
another
worksheet?