Entering the same text into multiple cells on multiple worsheets

[kyrospeare]

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]

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 were:

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

I also tried:

=Sheet6!C35

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

Thanks.

[Kletcho]

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.