How do i copy only the subtotals inserted into a list?

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

Guest

I have a list that I have inserted subtotals into, with Data, Subtotals. For
instance, a count function that counts the items in a list when the data in
the first column changes. Then i only want to copy the subtotal data, only
the counts of the first column items. I only need the subtotals (counts) not
the detail list. How do i do this?
 
Use the outlining symbols to the left to hide the stuff you don't want.

Select the range to copy
edit|goto|special
select visible cells
edit|copy

And then select the destination cell and edit|paste.
 
Thanks! .. it is always the little things ..this has been bugging me for some
time, and no one in my office could answer it! .. made my week!
 

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

Conditional SUBTOTAL in XL210 Table 7
description of count in subtotal 1
Getting Text data using the Data - Subtotal feature 1
Copying only subtotals 1
Subtotal To Include Item Description On Subtotal Line 2
Pivot Table Formula Problem 1
Copy within a subtotal 1
Excel subtotals 1

Back
Top