Try ='[Workbookname.xls]Sheet1'!A1

where Workbookname.xls is the name of your file, Sheet1 is the name of the
worksheet in that file and A1 is the cell in the specified worksheet.

--
Kevin Backmann


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