| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to hyperlink from a workbook to sheets in another workbook?
I have 2 workbooks. Workbook 1 is called: Status. Workbook 2 is called Issues.
In the Status Workbook, cell A1 contains ID numbers: 136/120/113 which refers to 3 issues. (Ideally, I do not want to split up the entry in cell A1) In the Issues Workbook; cell A2 in Sheet 1 has the issue details of 136 and cell A3, also in Sheet 1, has the issue details of 120. However, cell A4 in Sheet 2 has the issue details of 113. How do I create a hyperlink from the Status Workbook cell A1 that will point to cell A2 in Sheet 1; cell A3 in Sheet 1 AND cell A4 in Sheet 2, in the Issues workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting all sheets in a workbook to print the same | Excel Discussion (Misc queries) | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
| copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
| how can i link sheets in my excel workbook | Excel Worksheet Functions | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Linear Mode
