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

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

Thanks Eric-

I have both workbooks open and performed the task that you indicated. When
I select the cell from workbook 1 after performing the actions you provided,
I can see the formula that was created but it is not linking to the new
workbook's worksheet?
--
KM


"Eric G" wrote:

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

What does the formula look like? Can you copy it and paste it here so I can
see it?


"Kelly M" wrote:

Thanks Eric-

I have both workbooks open and performed the task that you indicated. When
I select the cell from workbook 1 after performing the actions you provided,
I can see the formula that was created but it is not linking to the new
workbook's worksheet?
--
KM

=[Reports.\xls]ERS!$B$1
--
KM


"Eric G" wrote:

What does the formula look like? Can you copy it and paste it here so I can
see it?


"Kelly M" wrote:

Thanks Eric-

I have both workbooks open and performed the task that you indicated. When
I select the cell from workbook 1 after performing the actions you provided,
I can see the formula that was created but it is not linking to the new
workbook's worksheet?
--
KM