How do I copy only subtotals to a new sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
Select the range, press F5, select special and visible cells only, copy and
paste

Regards,

Peo Sjoblom
 
Hi
The way I do it is to set the grouping to display just the totals. Hit F5
and from Special select visible cells. Copy and Edit|Paste Special|Values
where you want them to go!

Andy.
 
You must log in or register to reply here.

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

To copy subtotal into another sheet 3
subtotal copy and paste 3
Copying only subtotals 1
subtotals copying 3
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
subtotal titles 1
Copy within a subtotal 1

Back
Top