How do I copy subtotaled data without the underlying details?

D

DBergesen

I want to copy the subtotaled data to another part of the worksheet or a new
worksheet without the underlying details. If I click and drag the area I want
to copy it picks up all the hidden rows. I don't want them.
 
R

Ron Coderre

Try this:

Hide the detail rows
Select the range you want to copy
Edit>Goto>
Click the [Special Cells] button
Select: Visible Cells

Edit>Copy

Go to the destination range
Edit>Paste Special>Values


Does that help?

***********
Regards,
Ron
 

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

Embed the same Excel multiple times 0
Additonal info into newly created Subtotal row 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Can I use the subtotal function while a worksheet is protected? 0
How do I copy subtotaled data without underlying details in Excel 1
Copy summary data to new sheet 1
Getting Text data using the Data - Subtotal feature 1
subtotal, match? 10

Top