software

I have an excel book with numerous pages and total amounts on each one. I
want a seperate page with all these totals, grand totals, on and I want it to
be connected to the pages in the workbook so the amount changes on the grand
totals page. To make life easier I don't mind being e-mailed at,
. Thanks, Elaine.

See Excel Help on quot;linked cellsquot;

You can link cells on separate worksheets to one master sheet.

The linked cells will update on the master as they change on the sheets.

e.g.

To sum up the same cell on each sheet into the master sheet enter this formula
on the master in a cell.

=Sum(Sheet1:Sheet4!H23)

This will sum up H23 on each of Sheet1 through Sheet4 to give a grand total.Gord Dibben MS Excel MVPOn Tue, 25 Apr 2006 14:19:01 -0700, misselainei
gt; wrote:

gt;I have an excel book with numerous pages and total amounts on each one. I
gt;want a seperate page with all these totals, grand totals, on and I want it to
gt;be connected to the pages in the workbook so the amount changes on the grand
gt;totals page. To make life easier I don't mind being e-mailed at,
. Thanks, Elaine.Thanks Gord for getting back to me so quickly. I have read the, quot;linked
cellsquot;, help bit but it really doesn't make any sense to me. I'm not thick,
I just don't understand all the jargon. Can you be more specific about how I
do it. Thanks, Elaine.

quot;Gord Dibbenquot; wrote:

gt; See Excel Help on quot;linked cellsquot;
gt;
gt; You can link cells on separate worksheets to one master sheet.
gt;
gt; The linked cells will update on the master as they change on the sheets.
gt;
gt; e.g.
gt;
gt; To sum up the same cell on each sheet into the master sheet enter this formula
gt; on the master in a cell.
gt;
gt; =Sum(Sheet1:Sheet4!H23)
gt;
gt; This will sum up H23 on each of Sheet1 through Sheet4 to give a grand total.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt;
gt; On Tue, 25 Apr 2006 14:19:01 -0700, misselainei
gt; gt; wrote:
gt;
gt; gt;I have an excel book with numerous pages and total amounts on each one. I
gt; gt;want a seperate page with all these totals, grand totals, on and I want it to
gt; gt;be connected to the pages in the workbook so the amount changes on the grand
gt; gt;totals page. To make life easier I don't mind being e-mailed at,
gt; . Thanks, Elaine.
gt;
gt;

The example should show the basics of cell linking between sheets.

Send me a copy of the workbook and I'll have a look at it.

Change the lt;ATgt; and lt;DOTgt; to get my email address. Do not send the file to the
news group.Gord

On Tue, 25 Apr 2006 15:51:02 -0700, misselainei
gt; wrote:

gt;Thanks Gord for getting back to me so quickly. I have read the, quot;linked
gt;cellsquot;, help bit but it really doesn't make any sense to me. I'm not thick,
gt;I just don't understand all the jargon. Can you be more specific about how I
gt; do it. Thanks, Elaine.
gt;
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; See Excel Help on quot;linked cellsquot;
gt;gt;
gt;gt; You can link cells on separate worksheets to one master sheet.
gt;gt;
gt;gt; The linked cells will update on the master as they change on the sheets.
gt;gt;
gt;gt; e.g.
gt;gt;
gt;gt; To sum up the same cell on each sheet into the master sheet enter this formula
gt;gt; on the master in a cell.
gt;gt;
gt;gt; =Sum(Sheet1:Sheet4!H23)
gt;gt;
gt;gt; This will sum up H23 on each of Sheet1 through Sheet4 to give a grand total.
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt;
gt;gt; On Tue, 25 Apr 2006 14:19:01 -0700, misselainei
gt;gt; gt; wrote:
gt;gt;
gt;gt; gt;I have an excel book with numerous pages and total amounts on each one. I
gt;gt; gt;want a seperate page with all these totals, grand totals, on and I want it to
gt;gt; gt;be connected to the pages in the workbook so the amount changes on the grand
gt;gt; gt;totals page. To make life easier I don't mind being e-mailed at,
gt;gt; . Thanks, Elaine.
gt;gt;
gt;gt;