+ Reply to Thread
Results 1 to 2 of 2

Click link to go to sheet in another workbook

  1. #1
    Forum Contributor
    Join Date
    11-14-2004
    Location
    Watford, England
    MS-Off Ver
    Microsoft Office 365
    Posts
    104

    Click link to go to sheet in another workbook

    Hi there,

    I have a workbook (workbook 1.xls) and in call A2 I have the text 901 now what I would like to do is make that a link to another workbook called "workbook 2.xls" and open it in cell A1 on sheet "901 (914)" so that when I click on 901 in workbook 1 it will open workbook 2.xls and go to that sheet.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    07-16-2008
    Location
    USA
    Posts
    142

    Re: Click link to go to sheet in another workbook

    Use the Insert function and insert a hyperlink to the file. Once the file link is added, manually add the following to the end:

    #SheetName!CellReference (ie. workbook_2.xls#901!A1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1