How to hyperlink from a workbook to sheets in another workbook?

M

MJOHNSON

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?
 

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

selecting workbook/sheet 3
Using names referencing a cell in another workbook 2
Referencing another workbook using a variable for the sheet? 20
copy specific cells from sheets if the information is correct 3
trouble with (complicated) vlookup searching another workbook 2
Hyperlink problems 1
CountIf from multiple sheets in another workbook 4
Cells Fill Automatically on Another Workbook 0

Top