Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I set up a formula to capture info from many other cells?
I have a document with several worksheets. I need to capture information in a
cell that comes from several other cells. I would like the information from the other cells to show sequentially or one on top of the other in the original cell. |
#2
|
|||
|
|||
What is the commonality between the worksheets? What are you trying to
reference? |
#3
|
|||
|
|||
Hi Joel,
What I understand, I think, a simple "&" funtion will work fine for you : For instance : =Sheet2!E14+Sheet3!D13+Sheet4!E14+Sheet5!D13 Please confirm, if this is not what you need. Thanks, Manish "JoelWMD" wrote: I have a document with several worksheets. I need to capture information in a cell that comes from several other cells. I would like the information from the other cells to show sequentially or one on top of the other in the original cell. |
#4
|
|||
|
|||
Sorry...please use the following function:
=Sheet2!E14&" "&Sheet3!D13&" "&Sheet4!E14&" "&Sheet5!D13 This will sequntially show the nos. in your different sheet in ONE CELL in the order in which you will define the formula. Each no. will be separated by a space. "Manish Bajpai" wrote: Hi Joel, What I understand, I think, a simple "&" funtion will work fine for you : For instance : =Sheet2!E14+Sheet3!D13+Sheet4!E14+Sheet5!D13 Please confirm, if this is not what you need. Thanks, Manish "JoelWMD" wrote: I have a document with several worksheets. I need to capture information in a cell that comes from several other cells. I would like the information from the other cells to show sequentially or one on top of the other in the original cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |