How do I copy sub total data only onto a new worksheet?

  • Thread starter Thread starter khuff
  • Start date Start date
K

khuff

When subtotaling a large amount of data I would like to be able to copy and
paste just the subtotal-ed information. When I try to do this I cant figure
out how to eliminate the underlying data from copying too.
 
Hi,

Select your data and press F5, Special, Visible cells only, OK. Then copy.

If this helps, please click the yes button

Cheers,
Shane Devenshire
 
Thanks Shane,

That F5 key seems to be helpful to know. Is there another way to get to that
tool other than using the F5 key?
 

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

Getting Text data using the Data - Subtotal feature 1
Copying only subtotals 1
Copy Sub Totals 4
Copy within a subtotal 1
Help me Please! Reference cell working w subtotals 2
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL 1
Paste Special Values 2
Sub total sorting 1

Back
Top