To add to what Gord said, I often do something like this:
=if(isblank(Sheet1!C3),"",Sheet1!C3)
That way, you won't get a 0 in the cell in which the formula resides when
Sheet1!C3 is blank.

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Tom

In D4 of sheet2 enter =Sheet1!C3

Another way is to enter an = sign in D4 then switch to sheet1 and select
C3 and
hit ENTER key.

And one more...........select C3 and switch to sheet2, select D4 and
EditPaste
SpecialPaste LinkOKEsc.

In all cases, D4 will get the above formula.


Gord Dibben MS Excel MVP

On Fri, 16 Mar 2007 16:08:10 -0700, Tom
wrote:

I'm looking for a formula (I think a formula, or some other way) whereby I
enter data in one cell on one worksheet and it simultaneously (or after a
keystroke or two) fills in the same data in a cell that I select on
another
worksheet, all within the same workbook. E.g., I type in the name "Roger"
in
cell C3 on sheet 1. I would have previously set up a condition in a
formula
or some other way whereby anything I type in cell C3 of sheet 1 is
repeated
in cell D4 of sheet 2. In other words, Excel does the "copying"
on-the-fly
using my pre-determined cells, i.e., anything I type in C3 is
automatically
filled in D4 of another sheet I specify.