if it is one cell only try this
suppose you want sheet1 A1 to be copied in sheet2 A1 then in sheet 2 A1 type
=sheet1!A1
now whatever you type in sheet1 A1 will be copiesd in sheet2 A1
if there are many cells
name the range in A1 sheet1 e.g. RV

goto sheet 2 highlight thes same n;umber of cells and type
=RV
and hit *********control+shift+enter
as this is an erray formula

otherwise you can create a macro in vba


--
remove $$$ from email addresss to send email

===============


"Matt Hall" <Matt wrote in message
...
i am trying to find out how i can type text in an excel cell and have it
automatically inserted in another worksheet.
is this possible?? if so how??

cheers.