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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup a subtotal 2
Problem with subtotal function 0
Subtotal of adjacent coloumn 4
Additonal info into newly created Subtotal row 1
Using the Subtotal function 2
Subtotaling 1
subtotal, match? 10
SubTotal 1

Top