All I'm able to do here is to repeat my original instructions.
Re-read my first post.
After you collapse and then select, didn't I say hit <F5>?
That means function key F5!
This brings up the "Go To" dialog box with buttons on the right side, one of
which is "Special".
Click on "Special", which was my second instruction.
This brings up the "Go To Special" dialog box.
There are two columns of choices in this window.
In the right column you'll see that one of the choices is "Visible Cells
Only".
Click on the "Visible Cells Only", which was my third instruction.
NOW, you click on the <OK> button on the extreme right side.
That was my fourth instruction.
Now, I'm copying here my second posts description of what you should see and
do:
<<<<<<<<<<<<<<<<<<<
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.
<<<<<<<<<<<<<<<<<<
While you have the numerous rows of marching ants, navigate to where you
wish to copy these subtotals and right click in the cell and choose "Paste".
Any other questions?
