Linking two cells of text together
 

I am trying to link two cells together one cell is in one work sheet and the
other cell is in another worksheet both sheets are in the same workbook. What
I am trying to do with them is when I type same a name in one cell I want it
to already fill itself into the other cell on the other worksheet.

Please help.
Thank you,

Linking two cells of text together
 

On Aug 11, 7:04�am, akarmyguy
wrote:
I am trying to link two cells together one cell is in one work sheet and the
other cell is in another worksheet both sheets are in the same workbook. What
I am trying to do with them is when I type same a name in one cell I want it
to already fill itself into the other cell on the other worksheet.

Unless you are wanting something else which you have not clearly
described . . .

In the "other" worksheet click on the "other" cell and type
"=" (without quotes).
Select the "one" worksheet and click on the "one" cell.
Press return.

Alan Lloyd

Linking two cells of text together
 

Formula:

=CONCATENATE(ref1,ref2)

"akarmyguy" wrote:

I am trying to link two cells together one cell is in one work sheet and the
other cell is in another worksheet both sheets are in the same workbook. What
I am trying to do with them is when I type same a name in one cell I want it
to already fill itself into the other cell on the other worksheet.

Please help.
Thank you,

Linking two cells of text together
 

Sorry I was typing a little fast.

ok here is my situation. I have 4 worksheets and I am trying to type some
text in cell A24 and have that same text automaticly typed into the other
worksheet in cell B20 when I hit the enter key.

I have already tried the typing "=" in it then clicking on the cell in the
other worksheet and it hasnt worked.

" wrote:

On Aug 11, 7:04�am, akarmyguy
wrote:
I am trying to link two cells together one cell is in one work sheet and the
other cell is in another worksheet both sheets are in the same workbook. What
I am trying to do with them is when I type same a name in one cell I want it
to already fill itself into the other cell on the other worksheet.

Unless you are wanting something else which you have not clearly
described . . .

In the "other" worksheet click on the "other" cell and type
"=" (without quotes).
Select the "one" worksheet and click on the "one" cell.
Press return.

Alan Lloyd

Linking two cells of text together
 

Go to your destination worksheet, click in cell B20, type = then go to your
source worksheet and click in cell A24 so that the relevant sheetname & cell
reference are added to the B20 formula after the = sign, then hit enter. It
should show something like =sheet2!A24 in the formula bar for B20, and
anything you enter in A24 in the source sheet will show in B20 in the
destination sheet.
--
David Biddulph

akarmyguy wrote:
Sorry I was typing a little fast.

ok here is my situation. I have 4 worksheets and I am trying to type
some text in cell A24 and have that same text automaticly typed into
the other worksheet in cell B20 when I hit the enter key.

I have already tried the typing "=" in it then clicking on the cell
in the other worksheet and it hasnt worked.

" wrote:

On Aug 11, 7:04?am, akarmyguy
wrote:
I am trying to link two cells together one cell is in one work
sheet and the other cell is in another worksheet both sheets are in
the same workbook. What I am trying to do with them is when I type
same a name in one cell I want it to already fill itself into the
other cell on the other worksheet.

Unless you are wanting something else which you have not clearly
described . . .

In the "other" worksheet click on the "other" cell and type
"=" (without quotes).
Select the "one" worksheet and click on the "one" cell.
Press return.

Alan Lloyd