How do I copy subtotaled data without the underlying details?

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

Guest

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.
 
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
 
Back
Top