automatic copy cells into other worksheet??
 

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.

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


"Matt Hall" wrote:

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.

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.