subtotals to a different page.

[Neophyte]

Is it easily doable to have the subtotals from sheet 1 calculate (show?) on
sheet 2? I have used the Data->Subtotals to get what I want on the sheet but
when I want to copy only the subtotals to another sheet, I get all the
cells. I have been exporting the info to Access and then doing a selective
import and filter and then exporting it back to Excel. Very round about and
clumsy.
Thanks you very much for looking and any answers.
Lee

 

[Dave Peterson]

Do your data|subtotals
use the outlining symbols to the left to hide all the details
select the range to copy
Edit|goto|special|visible cells only
edit|copy

off to the other sheet
edit|paste

 

[Neophyte]

Wow, That is simple!!
Thanks,
Lee

Do your data|subtotals
use the outlining symbols to the left to hide all the details
select the range to copy
Edit|goto|special|visible cells only
edit|copy

off to the other sheet
edit|paste

 

[RagDyer]

If you do this often, you might like to place the 'Visible Cells' icon onto
your toolbar, to make it even *simpler*.

Right click in the toolbar and choose "Customize".
Click on the "Commands" tab.
In the left window, click on "Edit".
In the right window, scroll down, almost to the bottom,
and click on the "Select Visible Cells" icon, and drag it to your toolbar.
--
HTH,

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

Wow, That is simple!!
Thanks,
Lee