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

"farley" wrote:

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