PDA

View Full Version : In excel when I'm on sheet1 a1 cell and I want sheet2 c1 cell text appear sheet1 b1?


M-Junaid
Apr 23, 2012, 12:50 AM
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

ScottGem
Apr 23, 2012, 03:32 AM
To link to the contents of another cell simply type = and then the cell address or navigate to the cell and select it.

M-Junaid
Apr 23, 2012, 04:04 AM
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.

ScottGem
Apr 23, 2012, 04:35 AM
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.

M-Junaid
Apr 23, 2012, 04:56 AM
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?

ScottGem
Apr 23, 2012, 05:27 AM
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.

M-Junaid
Apr 23, 2012, 06:46 AM
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?

ScottGem
Apr 23, 2012, 06:58 AM
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?

M-Junaid
Apr 23, 2012, 07:26 AM
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??

ScottGem
Apr 23, 2012, 08:32 AM
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.

JBeaucaire
Apr 24, 2012, 05:23 AM
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