Hi Teresa

I'm sorry that didn't work. Another way to link cells/sheets is:

Click a cell in Sheet1
Click on the = sign under your toolbar
Click the sheet tab at the bottom of the screen you want to link Sheet1 to
Click the cell in the sheet you want to link to
Click OK

Hope this helps.

Richard


"Teresa" wrote:

Hi Richard,
No that didn't work it gave me this message #REF. I have multiple sheets
that I need to carry certain information over to sheet one and keep getting
various errors.

"Richard" wrote:

Try the following formula in Sheet1 column A
=(Sheet2!A3)
--
Richard


"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?