How do I copy only subtotals to a new sheet?
 

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.

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" wrote in message
...
Not including selecting each one individually.