How do I copy subtotaled data without the underlying details?
 

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.

How do I copy subtotaled data without the underlying details?
 

Try this:

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

EditCopy

Go to the destination range
EditPaste SpecialValues


Does that help?

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


"DBergesen" wrote:

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.