software

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
Editgt;Gotogt;
Click the [Special Cells] button
Select: Visible Cells

Editgt;Copy

Go to the destination range
Editgt;Paste Specialgt;ValuesDoes that help?

***********
Regards,
Ronquot;DBergesenquot; wrote:

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