How do I copy only subtotals to a new sheet?

Not including selecting each one individually.

Hi
The way I do it is to set the grouping to display just the totals. Hit F5
and from Special select visible cells. Copy and Edit|Paste Special|Values
where you want them to go!

Andy.

"darlinvee" <[email protected]> wrote in message
news:[email protected]...
> Not including selecting each one individually.

Select the range, press F5, select special and visible cells only, copy and
paste

Regards,

Peo Sjoblom

"darlinvee" wrote:

> Not including selecting each one individually.