software

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

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

--

Regards,

Peo Sjoblom

quot;bfordmelsonquot; gt; wrote in message
...
gt; How do I copy/paste subtotaled data without also copying the detail
(hidden
gt; rows)?
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;Values

Is that what you're looking to do?

***********
Regards,
Ronquot;bfordmelsonquot; wrote:

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