I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

Well you could just copy and past from one to the other. Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well.

"kmb0702" wrote:

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

Hi,

assuming that you text is on cell A1

just use =a1

HTH
Regards from Brazil
Marcelo



"kmb0702" escreveu:

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

I know how to copy from worksheet to worksheet. What I am trying to do is
show a text from a different workbook. I have tried different methods and the
only closest one comes up with a "0" in it.

"tim m" wrote:

Well you could just copy and past from one to the other. Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well.

"kmb0702" wrote:

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

The cell you are copying has text in it and not a formula that displays text?
(Copying straight text from one workbook to another should be exactly the
same as copying from one worksheet to another.)

Perhaps try 'copy'....'paste special'...'values'

"kmb0702" wrote:

I know how to copy from worksheet to worksheet. What I am trying to do is
show a text from a different workbook. I have tried different methods and the
only closest one comes up with a "0" in it.

"tim m" wrote:

Well you could just copy and past from one to the other. Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well.

"kmb0702" wrote:

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

What I mean by copying is that the 2 are linked together where I can change
one and the other will change as well. Copying it just doesn't formulate
anything for me I want the ability to have them both be the same.



"tim m" wrote:

The cell you are copying has text in it and not a formula that displays text?
(Copying straight text from one workbook to another should be exactly the
same as copying from one worksheet to another.)

Perhaps try 'copy'....'paste special'...'values'

"kmb0702" wrote:

I know how to copy from worksheet to worksheet. What I am trying to do is
show a text from a different workbook. I have tried different methods and the
only closest one comes up with a "0" in it.

"tim m" wrote:

Well you could just copy and past from one to the other. Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well.

"kmb0702" wrote:

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

Did you try this part of my previous post?....

Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well

"kmb0702" wrote:

What I mean by copying is that the 2 are linked together where I can change
one and the other will change as well. Copying it just doesn't formulate
anything for me I want the ability to have them both be the same.



"tim m" wrote:

The cell you are copying has text in it and not a formula that displays text?
(Copying straight text from one workbook to another should be exactly the
same as copying from one worksheet to another.)

Perhaps try 'copy'....'paste special'...'values'

"kmb0702" wrote:

I know how to copy from worksheet to worksheet. What I am trying to do is
show a text from a different workbook. I have tried different methods and the
only closest one comes up with a "0" in it.

"tim m" wrote:

Well you could just copy and past from one to the other. Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well.

"kmb0702" wrote:

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

I have already tried that and that is where I still get an error or just get
a zero. They are both formatted for text so it is not a format issue.

"tim m" wrote:

Did you try this part of my previous post?....

Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well

"kmb0702" wrote:

What I mean by copying is that the 2 are linked together where I can change
one and the other will change as well. Copying it just doesn't formulate
anything for me I want the ability to have them both be the same.



"tim m" wrote:

The cell you are copying has text in it and not a formula that displays text?
(Copying straight text from one workbook to another should be exactly the
same as copying from one worksheet to another.)

Perhaps try 'copy'....'paste special'...'values'

"kmb0702" wrote:

I know how to copy from worksheet to worksheet. What I am trying to do is
show a text from a different workbook. I have tried different methods and the
only closest one comes up with a "0" in it.

"tim m" wrote:

Well you could just copy and past from one to the other. Or if you put the
cell address from the 1st sheet into the 2nd sheet the text should show up.
For example:
Double click the cell in sheet to and type the = sign, then go to sheet one
and put the cursor in the cell that has the text you want and hit return.
Then go back to sheet 2 and you will see that it has the text from sheet 1.
If the text in sheet 1 changes the text in sheet 2 will changes as well.

"kmb0702" wrote:

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.