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

Text works the same way. (I'd guess a typing error????) or maybe you have
#Value! in that cell?

And you may want to use something like:

=if(sheet1!a1="","",sheet1!a1)

Then empty cells won't return 0's.

And if it wasn't a typo, you could hide the error by:
=if(iserror(sheet1!a1),"",if(sheet1!a1="","",sheet 1!a1))





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

--

Dave Peterson

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