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.