After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal
M Mark Jul 15, 2008 #1 After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal
B Bob Phillips Jul 15, 2008 #2 You can, but you will need to PasteSpecial>Values if you want that exact value. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
You can, but you will need to PasteSpecial>Values if you want that exact value. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
S Spiky Jul 15, 2008 #3 After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal Click to expand... Also, you probably need to select the column of Subtotals, then use Goto|Special to select Visible Cells Only, then hit Copy.
After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal Click to expand... Also, you probably need to select the column of Subtotals, then use Goto|Special to select Visible Cells Only, then hit Copy.
