Subtotals
 

In a spreadsheet, I've used the DataSubtotals menu item and collapsed all
so only the subtotal values are displayed. I would like to copy and paste
only the subtotal values to another location, but when I try to do so, the
details of each subtotal are also copied. Is there a way to copy only the
subtotal values?

Ivor

First: EditGoTo...Special..."Visible Cells Only"OK
Then: Copy, PasteSpecialValues (followed by PasteSpecialFormats, if
desired)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Ivor Williams" wrote in message
news:6xNJe.144788$%K2.13225@pd7tw1no...
In a spreadsheet, I've used the DataSubtotals menu item and collapsed all
so only the subtotal values are displayed. I would like to copy and paste
only the subtotal values to another location, but when I try to do so, the
details of each subtotal are also copied. Is there a way to copy only the
subtotal values?

Ivor