automatic copy cells into other worksheet??

[Guest]

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.

 

[Guest]

Hiiiiiiii dear
hope u are ok
go the sheet2 cell A1 and type =Sheet1!A1
and Drag it
and now go to sheet1 and type something in Cell A1 and A2 and A3 and then
check them in sheet2 Colum u will find what u have written
hope it may work for uuuuu
good luck

 

[R.VENKATARAMAN]

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