Are the sheets in the same workbook? If not, are both workbooks open in the
same instance of Excel?

"Teresa" wrote:

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?