software

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

--

Dave Peterson

Wow, That is simple!!
Thanks,
Lee

quot;Dave Petersonquot; gt; wrote in message
...
gt; Do your data|subtotals
gt; use the outlining symbols to the left to hide all the details
gt; select the range to copy
gt; Edit|goto|special|visible cells only
gt; edit|copy
gt;
gt; off to the other sheet
gt; edit|paste
gt;
gt;
gt;
gt; Neophyte wrote:
gt;gt;
gt;gt; Is it easily doable to have the subtotals from sheet 1 calculate (show?)
gt;gt; on
gt;gt; sheet 2? I have used the Data-gt;Subtotals to get what I want on the sheet
gt;gt; but
gt;gt; when I want to copy only the subtotals to another sheet, I get all the
gt;gt; cells. I have been exporting the info to Access and then doing a
gt;gt; selective
gt;gt; import and filter and then exporting it back to Excel. Very round about
gt;gt; and
gt;gt; clumsy.
gt;gt; Thanks you very much for looking and any answers.
gt;gt; Lee
gt;
gt; --
gt;
gt; Dave Peterson
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 quot;Customizequot;.
Click on the quot;Commandsquot; tab.
In the left window, click on quot;Editquot;.
In the right window, scroll down, almost to the bottom,
and click on the quot;Select Visible Cellsquot; icon, and drag it to your toolbar.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Neophytequot; gt; wrote in message
...
gt; Wow, That is simple!!
gt; Thanks,
gt; Lee
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; Do your data|subtotals
gt; gt; use the outlining symbols to the left to hide all the details
gt; gt; select the range to copy
gt; gt; Edit|goto|special|visible cells only
gt; gt; edit|copy
gt; gt;
gt; gt; off to the other sheet
gt; gt; edit|paste
gt; gt;
gt; gt;
gt; gt;
gt; gt; Neophyte wrote:
gt; gt;gt;
gt; gt;gt; Is it easily doable to have the subtotals from sheet 1 calculate
(show?)
gt; gt;gt; on
gt; gt;gt; sheet 2? I have used the Data-gt;Subtotals to get what I want on the
sheet
gt; gt;gt; but
gt; gt;gt; when I want to copy only the subtotals to another sheet, I get all the
gt; gt;gt; cells. I have been exporting the info to Access and then doing a
gt; gt;gt; selective
gt; gt;gt; import and filter and then exporting it back to Excel. Very round about
gt; gt;gt; and
gt; gt;gt; clumsy.
gt; gt;gt; Thanks you very much for looking and any answers.
gt; gt;gt; Lee
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt;
gt;