Using the Subtotal function
 

After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I
copy just the subtotal

Using the Subtotal function
 

You can, but you will need to PasteSpecialValues if you want that exact
value.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mark" wrote in message
...
After i have Subtotaled a spreadsheet, then collapsed to show subtotals
can I
copy just the subtotal

Using the Subtotal function
 

On Jul 15, 12:41 pm, Mark wrote:
After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I
copy just the subtotal

Also, you probably need to select the column of Subtotals, then use
Goto|Special to select Visible Cells Only, then hit Copy.