Copy subtotals without hidden rows
 

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

Copy subtotals without hidden rows
 

Select the range, press F5, click special and select visible cells only,
click OK, copy and paste

--

Regards,

Peo Sjoblom

"bfordmelson" wrote in message
...
How do I copy/paste subtotaled data without also copying the detail
(hidden
rows)?

Copy subtotals without hidden rows
 

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)?