David

What you want to do is doable using your method no matter if text or numeric
data.

In Sheet2 in a cell enter =Sheet1!A1

If you are seeing the formula it is possible the cell was formatted to Text
prior to entering the formula.

Change its format to General and F2 + ENTER to re-enter the formula.

Gord Dibben Excel MVP

On Thu, 16 Dec 2004 15:09:03 -0800, "David"
wrote:

I am wondering how to copy a cell that contains text from one worksheet to
another. In other words I have two woorksheets in the same book, lets call
them Sheet1 and sheet 2.

Sheet1 has a column of company names in call it column A and figures in
column B.
Sheet 2 has a report that will change. I would like to be able to write
='Sheet1'!A1 into the cell so that no matter what I type in Sheet1 cell A1 it
will copy that information over to Sheet2.

I can do this with numbers but is there a way to copy text. All I get is the
formula, and when I tried in a new sheet I got #VALUE!

Any help would be appreciated