Hyperlinks to Another Workbook

  • Thread starter Thread starter MissLabeled
  • Start date Start date
M

MissLabeled

I had been reading the various hyperlinking questions and haven't
found exactly what I'm looking for. I need to hyperlink from one
workbook to a specific sheet in another workbook. I have a master
list of files and some of them are number like 166 and 166-A.
Anything for 166 is in the same workbook, but I would like to link the
166-A reference directly to the "Schedule A" workbook and sheet.
Right now all of the 166s link to the 166 file and you have to go to
the correct tab from there. It would be great if I could send people
to the right sheet directly.

Thanks!
 
The steps are slightly different, depending on which version of Excel
you're using. In Excel 2002:

1. Select the cell in which you want the hyperlink
2. Choose Insert>Hyperlink
3. In the bar at the left, click on 'Existing File or Web page'
4. From the list in the centre, select the file
5. Click the Bookmark button
6. Choose a Sheet or Defined Name
7. Click OK, click OK
 
Back
Top