How do I set up a formula to capture info from many other cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
What is the commonality between the worksheets? What are you trying to
reference?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum same cell across multiple worksheet function does not work... 1
How do I fill a formula on another sheet that repeat every 50 cell 3
Moving Cell Formula 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel VBA 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to capture Username into specific cells 6
Convert number to text as displayed 3

Back
Top