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

Is that what you're looking to do?

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


"bfordmelson" wrote:

How do I copy/paste subtotaled data without also copying the detail (hidden
rows)?