I need to copy a text value from one worksheet to another

[Guest]

I am creating a report for my boss. In one worksheet I have fields where she
can enter text or numbers. Then in another worksheet I have some formulas
that work off the previous worksheet. I need a function that will copy the
text in a column on the first worksheet and place it in a specified cell on
the other worksheet.

I hope this makes sense. Example:
Cell A1 in Worksheet 1 = Financial Manager
Now I want to copy Financial Manager into Cell B4 in Worksheet 2

The trick is the text in cell A1 in Worksheet 1 will always change depending
on what my boss puts in it. But I want it to always copy to a specified cell
in the other worksheet.

Thank you!

 

[Guest]

In B4 in sheet 2 put =Sheet1!A1

That will put the contents of A1 in sheet 1 into that cell, when A1 changes
the result will change in B4 sheet 2.

Is that what you wanted?

 

[Guest]

Thanks for responding.

I tried that and then my cell B4 doesn't display what is in the cell of A1
it displays the formula. How can I get it to hide the formula and just show
the value of field A1?

Thanks a bunch!

 

[Guest]

Hmph, it worked for me in my test. In sheet 2 under tools, options, view do
you have the 'formulas' box checked? If so uncheck it.

 

[Gord Dibben]

Toria

It is also possible that the cell that shows the formula was pre-formatted as
Text.

Format to General then F2 and ENTER.


Gord Dibben MS Excel MVP

 

[Guest]

Thank you Gord, that worked!!!!!

Toria

It is also possible that the cell that shows the formula was pre-formatted as
Text.

Format to General then F2 and ENTER.


Gord Dibben MS Excel MVP