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.
|