Good Evening:

I amtrying to enter text into one cell and have it automatically
copied to another cell in another worksheet. How could I do this?

Thanks so much.


--
kyrospeare
------------------------------------------------------------------------
kyrospeare's Profile: http://www.excelforum.com/member.php...o&userid=33888
View this thread: http://www.excelforum.com/showthread...hreadid=536656

I tried entering =IF(Sheet1!A1="","",Sheet1!A1) but it didn't work. The
formula just stayed in the box as if it were text to be printed.

The exact formulas I tried we

=IF(Sheet6!C35="","",Sheet6!C35)

I also tried:

=Sheet6!C35

I get nothing. The formula just stays in the box.

Thanks.


--
kyrospeare
------------------------------------------------------------------------
kyrospeare's Profile: http://www.excelforum.com/member.php...o&userid=33888
View this thread: http://www.excelforum.com/showthread...hreadid=536656

That means you have the cells format set to text. So no matter what
you put in the cell it will think it is just supposed to be text.
Change the format of the cells to text. Then to get it to recalculate
the formula do a find and replace on the whole worksheet for = and then
replace it with =.

Does anyone out there know a better way to force calculation (other
than F9) then this find and replace trick? I have heard of a short cut
key something like ctrl + alt + F9 or something.