not sure if this is the best way, but it works for me

right click sheet one and click view code
paste the code.
then go to sheet1 and enter something from a1 to 10 and see if it shows up
on sheet2 in b1 to b10



Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("Sheet2").Range("B1:b10") = Sheets("Sheet1").Range("a1:a10").Value

End Sub

--


Gary


"markymark" wrote in message
...
Hi,

I'm trying to figure out how to automatically get cells to copy from one
worksheet into another once you enter data.

so if I enter a word into a cell it will automatically fill in another
cell in another worksheet in that same excel file.

Obviously this will help save some time from re-entering information.

Any help would be appreciated.

thanks,
t