Pasting subtotals only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I paste subtotals only of a list into another worksheet without the
background data?
 
Adjust the subtotals to your liking, select the range, press F5 and select
special and visible cells only
copy and paste
 
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

Copying only subtotals 1
subtotal copy and paste 3
copy and paste if 1
Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
Paste Special Values 2
Sorting Subtotals 11
Cut/Paste Subtotal Data 2

Back
Top