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 wrote:
>
> 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

[Neophyte]

Wow, That is simple!!
Thanks,
Lee

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> 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 wrote:
>>
>> 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

[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!
==============================================


"Neophyte" <[email protected]> wrote in message
news:Olk3%[email protected]...
> Wow, That is simple!!
> Thanks,
> Lee
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > 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 wrote:
> >>
> >> 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
>
>