Copy Subtotals to another worksheet

When using excel sub total function. How do I copy the sub total to another
worksheet?

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" <[email protected]> wrote in message
news:[email protected]...
> When using excel sub total function. How do I copy the sub total to
> another
> worksheet?