Link to open a pdf file

[theaton56]

Afternoon Ladies & Gants,

Wonder if someone could point me in the right direction.

I have a Test Kit Calibration list consisting of 3 worksheets.

The main worksheet is printed off and lists Asset Number and Cal Due date.

The 2nd worksheet has all the Asset Numbers and calibration due dates.

I use a drop down menu (linked to the 2nd sheet) so that the user can only select the correct Asset against the Device listing. This then pulls in the calibration date for that Asset using vlookup. This has worked extremely well for me for the past few months.

What I am now trying to do is have the Asset Numbers appear off printed area so when I click on that cell, it launched the Cal cert (in pdf form).

I have the 3rd sheet with the Asset Numbers and hyperlinks to individual pdf's and was going to use vlookup again.

However, this doesn't seem to work.

Does anyone know a way to achieve this ?

I have attached a token file that hopefully indicates my problem,

Thaks in advance,

Tony

[theaton56]

Issue resolved, anyone interested it was posted into the Formulas & Functions sub forum. My thanks to Kev who came up with VBA to resolve my issue.