subtotals to a different page.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neophyte - 17 Jan 2006 03:09 GMT

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

Reply to this Message

Dave Peterson - 17 Jan 2006 03:26 GMT

> 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
[quoted text clipped - 4 lines]
> Thanks you very much for looking and any answers.
> Lee

Signature

Dave Peterson

Reply to this Message

Neophyte - 17 Jan 2006 04:12 GMT

Wow, That is simple!!
Thanks,
Lee

> Do your data|subtotals
> use the outlining symbols to the left to hide all the details
[quoted text clipped - 17 lines]
>> Thanks you very much for looking and any answers.
>> Lee

Reply to this Message

RagDyer - 18 Jan 2006 00:00 GMT

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.

Signature

HTH,

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

> Wow, That is simple!!
> Thanks,
[quoted text clipped - 21 lines]
> >> Thanks you very much for looking and any answers.
> >> Lee

Reply to this Message