Copy subtotals

You just saved me a TON of work!!

Thanks for the very helpful post!

Erin


-----Original Message-----
If this has to be done often, there is an icon which can
be placed on the
tool bar for much easier and quicker utilization.

Right click in the tool bar and choose Customize,
Click on the Commands tab,
In the "Categories" window, click on Edit,
In the "Commands" window, scroll to the next to last icon,
which is the "Select Visible Cells" one,
Click on it and drag to the tool bar.

HTH,

RD




"JohnI in Brisbane"
wrote in message
...
Mary,

1) First select your data range as usual

2) Select "Edit" - Select "Go To..." -
Select "Special..." button - Select
"Visible Cells Only" - click "OK" button.

3) Click "Edit - Click "Copy"

4) Select where you want to paste.

5) Paste as usual

regards,

JohnI


"Mary" wrote in message
...
I would like to work with my collapsed subtotals
without
the associated detailed rows. When I try to copy a
set of
collapsed subtotals (that is, a set in which I have
clicked the #2 in the far left corner), and try to
copy
that information, it pastes the subtotals plus all of
the
hidden rows.

Can anyone tell me how I can work with only the
subtotals
of a spreadsheet?

Thanks




.

My Pleasure !
--


Regards,

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


"Erin Paulin" wrote in message
...
You just saved me a TON of work!!

Thanks for the very helpful post!

Erin


-----Original Message-----
If this has to be done often, there is an icon which can
be placed on the
tool bar for much easier and quicker utilization.

Right click in the tool bar and choose Customize,
Click on the Commands tab,
In the "Categories" window, click on Edit,
In the "Commands" window, scroll to the next to last icon,
which is the "Select Visible Cells" one,
Click on it and drag to the tool bar.

HTH,

RD




"JohnI in Brisbane"
wrote in message
...
Mary,

1) First select your data range as usual

2) Select "Edit" - Select "Go To..." -
Select "Special..." button - Select
"Visible Cells Only" - click "OK" button.

3) Click "Edit - Click "Copy"

4) Select where you want to paste.

5) Paste as usual

regards,

JohnI


"Mary" wrote in message
...
I would like to work with my collapsed subtotals
without
the associated detailed rows. When I try to copy a
set of
collapsed subtotals (that is, a set in which I have
clicked the #2 in the far left corner), and try to
copy
that information, it pastes the subtotals plus all of
the
hidden rows.

Can anyone tell me how I can work with only the
subtotals
of a spreadsheet?

Thanks




.