Copying Subtotals

G

Gale

After a spreadsheet has been subtotaled, is there a way to
copy the subtotals only and paste to another document?

Thanks.
 
F

Frank Kabel

Hi
try the following after creating the subtotals
- group the range so that only the subtotals are visible
- select the range
- hit F5, click 'Special' and choose 'only visible cells'
- after this copy the range and paste it to a different location
 
Top