If you want anything you type in Sheet1 cell A2 appear in Sheet 2 cell B3,
then click in Sheet 2 cell B3, type the = sign, then click in Sheet 1 cell
A2, and accept the formula. You'll get a formula that says =Sheet1!A2. If
you want your destination cell to stay empty until something has been typed
in the source cell, then use =IF(Sheet1!A2="","",Sheet1!A2).
--
David Biddulph

"i0ndrag0n" wrote in message
...
I know that you can have entered text appear in another worksheet using
CTRL
and clicking the tab for that worksheet, but can you have text you enter
appear automatically in a specifed cell on another worksheet? Using Excel
2000.