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.