|
Subject:
|
Hyperlink (Concatenate)
|
|
Posted By:
|
JEHalm
|
Post Date:
|
1/11/2006 11:52:21 AM
|
I am trying to hyperlink from one workbook to another. Aside from opening the destination workbok with the hyperlink, I would also like to display the value of a specific cell that resides in the destination workbook within the cell of the original workbook that contains the hyperlink.
I tried this at Mr. Excel but was told that a hyperlinked cell cannot be used to display a value from another workbook. But I do not think that is correct.
|
|
Reply By:
|
maccas
|
Reply Date:
|
1/11/2006 12:09:12 PM
|
You can do this:
- Take the workbook (1st) you want to create the externally linked hyperlink in and open it
- Also open the other workbook (2nd) that you want to link / hyperlink to
- In the 1st workbook in any cell start typing a formula (by typing =)
- Whilst still editing the formula switch to the 2nd workbook (by pressing Ctrl + F6 amongst other ways)
- Navigatve to the desired sheet in the 2nd workbook by clicking on the sheet tabs at the bottom
- Click on the cell whose value you'd like to externally link
- Press Enter
- Switch back to the 2nd workbook and close it
- In the first workbook click on the externally linked cell which will show the value of the other spreadsheet's cell
- Press Ctrl + K to bring up the Edit Hyperlinks dialog box
- Use the file browse dialog to navigate to the linked file (2nd workbook)
- Select the linked file and press ok
- You will have an externally linked hyperlinked cell
|
