It's easy if you have both workbooks open at the same time. In Wkbk1, select
the cell you want to link. Type "=". Then select Wkbk2. Then select the
sheet you want in that workbook ("Sht2"). Then select the cell you want to
link. Press Enter. The resulting formula in Wkbk1 will look something like:

=[Wkbk2]Sht2!$C$8

If you then close Wkbk2 (saving if necessary), the formula will change a
little and look like:

='C:\this\is\the\workbook\path\[Wkbk2.xls]Sht2'!$C$8

HTH,

Eric

"Kelly M" wrote:

I'm trying to link a particular cell in a workbook's worksheet (let's call it
workbook 1)to a cell in a specific workbook's worksheet (let's call it
workbook 2, worksheet 2). Can this be done? I have been able to link to a
new workbook, but not a specific worksheet in that workbook.
--
KM