Then you did something wrong!

After you hit <OK your selection should have white lines in it..
You must right click in *that* selection and choose "Copy", while you can
still see the white lines within that selection that represent the hidden
rows.

After you choose "Copy", your selection should be filled with the marquee
(marching ants) following those white lines, meaning that there are
*numerous individual* selections being sent to the clip-board as a single
item.

Try it again. It *does* work.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Diane" wrote in message
...
That sounds reasonable enough but it doesn't work. When you paste it you
get
the underlying data from the hidden rows as well. I need a way to only
copy
the exposed data, not the hidden data.

--
Thanks,
Diane


"RagDyer" wrote in message
...
Collapse the groups and select all the subtotals.
Hit <F5
Click on "Special"
Click on "Visible Cells Only"
Then <OK

Right click in the selection and choose "Copy"

Then navigate to wherever you wish, and then "Paste".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Diane" wrote in message
...
I have a worksheet with subtotals, but I'd like to take just those
subtotals
to another sheet for further manipulation. Any ideas?

Thanks,
Diane