Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
automatically drop data to next line | Excel Discussion (Misc queries) | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |