Click link to go to sheet in another workbook
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.
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)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1