How do I copy text from one workbook to another

K

kmb0702

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.
 
T

tim m

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.
 
M

Marcelo

Hi,

assuming that you text is on cell A1

just use =a1

HTH
Regards from Brazil
Marcelo



"kmb0702" escreveu:
 
K

kmb0702

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.
 
T

tim m

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'
 
K

kmb0702

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.
 
T

tim m

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
 
K

kmb0702

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.
 
Top