Link cell from Wkbk1 to a cell in a specific Worksht in Wkbk2

K

Kelly M

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.
 
E

Eric G

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
 
K

Kelly M

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 said:
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 said:
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.
Click to expand...
Click to expand...
 
E

Eric G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to create absolue path link to another workbook (Excel 2003) 1
link to a specific worksheet of a workbook with many worksheets 1
link to another document of Excel 2003 2
Link to specific cell in specific Excel file 3
How to extract email addresses from 1 worksheet to another workbook 11
Password Protect Specific Range Of Cells 6
Macro Copy Workbook Query 2

Top