In Sheet1, enter:
=Sheet2!A3

HTH
--
AP

"Teresa" a écrit dans le message de news:
...
I want to transfer certain cells from one sheet into another sheet. I can
not get the cell to work. I keep getting a error message. Could you
please tell me how to take the info form sheet 2 A3 and have it
automatically
transfer into sheet one colum A?