Not including selecting each one individually.
P Peo Sjoblom May 27, 2005 #2 Select the range, press F5, select special and visible cells only, copy and paste Regards, Peo Sjoblom
Select the range, press F5, select special and visible cells only, copy and paste Regards, Peo Sjoblom
A Andy B May 27, 2005 #3 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.
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.
