automatically transfer data from one spreadsheet to another

[farley]

how do i automatically transfer data entered in one spreadsheet to another
spreadsheet with the same workbook

 

[Mike]

Enter this into Sheet2 cell A1 then type data into Sheet1 cell A1
=(Sheet1!A1)