How do I automatically drop totals from one worksheet into another
 

I have created an Excel workboot that contains 5 worksheets. Four (4)
worksheets have totals for each row. I would like those totals to
automatically drop into corresponding columns/rows in the 5th worksheet. How
can I accomplish this?

Thanks for any help you can give.

=Sheet1A1 in any cell of Sheet2 will display the value in A1 of Sheet1
If sheet names have spaces in them you need ='October Sales'!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ladytar" wrote in message
...
I have created an Excel workboot that contains 5 worksheets. Four (4)
worksheets have totals for each row. I would like those totals to
automatically drop into corresponding columns/rows in the 5th worksheet.
How
can I accomplish this?

Thanks for any help you can give.

In general excel formula's do not "drop into" they "get from"

So,
On sheet 5
in the cell where you would like to see the result from sheet 4,
enter the = sign
click onto sheet 4 cell and push enter.

You can extend the formula on sheet 5.
Click onto the right hand bottom corner of the cell....
the mouse pointer will have changed to a + sign....
and drag down as far as necessary.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=472760

Thanks Bernard....I tried this and got an error....#NAME?
What did I do wrong?

"Bernard Liengme" wrote:

=Sheet1A1 in any cell of Sheet2 will display the value in A1 of Sheet1
If sheet names have spaces in them you need ='October Sales'!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ladytar" wrote in message
...
I have created an Excel workboot that contains 5 worksheets. Four (4)
worksheets have totals for each row. I would like those totals to
automatically drop into corresponding columns/rows in the 5th worksheet.
How
can I accomplish this?

Thanks for any help you can give.

Sorry Bernard....I tried it again...with the ! and it Worked!!!! Thanks a
millian!!

"Bernard Liengme" wrote:

=Sheet1A1 in any cell of Sheet2 will display the value in A1 of Sheet1
If sheet names have spaces in them you need ='October Sales'!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ladytar" wrote in message
...
I have created an Excel workboot that contains 5 worksheets. Four (4)
worksheets have totals for each row. I would like those totals to
automatically drop into corresponding columns/rows in the 5th worksheet.
How
can I accomplish this?

Thanks for any help you can give.

Thanks so much Bill....your information is very helpful.

"bill k" wrote:


In general excel formula's do not "drop into" they "get from"

So,
On sheet 5
in the cell where you would like to see the result from sheet 4,
enter the = sign
click onto sheet 4 cell and push enter.

You can extend the formula on sheet 5.
Click onto the right hand bottom corner of the cell....
the mouse pointer will have changed to a + sign....
and drag down as far as necessary.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=472760