In excel which type of symbol we use when I'm on sheet1 a1 cell and I want text of sheet2 c1 appear in sheet1 b1. Tell me the formula

To link to the contents of another cell simply type = and then the cell address or navigate to the cell and select it.

Quote:

---

Originally Posted by ScottGem

To link to the contents of another cell simply type = and then the cell address or navigate to the cell and select it.

---

Pleas read my complete question.

I did read your complete question and my response answers it. Your question is not entirely clear. The only thing I could get from what you posted was that you wanted to reference a value in another cell. There is no formula you can enter one cell to make a value appear in another cell. You would have to use a macro to do that.

Quote:

---

Originally Posted by ScottGem

I did read your complete question and my response answers it. Your question is not entirely clear. The only thing I could get from what you posted was that you wanted to reference a value in another cell. There is no formula you can enter in one cell to make a value appear in another cell. You would have to use a macro to do that.

---

Its not possible in excel?

U understood my question?

I said I'm not sure I understood your question and asked you to clarify. If you are asking what you can type in A1 to make a value appear in B1, yes that is impossible. You can create a macro to type something in B1.

No.
I said that, I'm on sheet1 in a1 cell and I want sheet2 cell c1 text appear in sheet 1 b1.
Its possible?

Yes that is possible and I told you how. In cell B1 you type = and then the cell address or navigate to the cell. Did you even try what I told you?

Yes I do many times.

But you don't understood my question properly.
I just want to say that, I am on sheet 1 or cell a1 and which type of formula or symbol we use that, sheet2 b2 cell text appear in sheet1 cell c1.

Understand??

One more try. You cannot type anything in a cell that will cause data to appear in another cell. I said that. You can place a formula in a cell to reference a value in another cell using =cell address, like I also explained.

If you want the value in Sheet2!B2 to appear in Sheet1!C1 then you have to enter
= Sheet2!B2 in C1. There is nothing you can enter A1 to make the text appear in C1.

Perhaps you should show your question to someone in your office as well as Scott's answer and see if they can spot the problem with either:

1) helping you correct your question so that it is understandable in a way that leads to a different answer

2) helping you apply the answer given in a way you can see it does answer your question