I need to copy a text value from one worksheet to another
Thank you Gord, that worked!!!!!
"Gord Dibben" wrote:
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
On Fri, 10 Nov 2006 14:15:02 -0800, Toria
wrote:
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!
"tim m" wrote:
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?
"Toria" wrote:
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!
|