Hi All,

I am starting to go crazy over the following one and would appreciate someone's professional advice.

I have a spreadsheet that contains details of 11,000 engineering drawings.

I wish to hyperlink each of these drawing register entries to the underlying .pdf file.

I can link these manually - by right click insert hyperlink and it works...

All the drawings are in the same folder so I figured on doing the following

A1 = file:\\\//BMASRM-SRV01\CPP Drawings\Drawings\CPP Scanned Drawings\CPP SCANS\ (This is the file location)
B1 = QSR-CR2-CIVL-500001-0 (This is the drawing no.)
C1 = .pdf (this is the file type extension)
D1 = =CONCATENATE(A1,B1,C1)
E1 = =HYPERLINK(D1,B1)

This is driving me nuts and I know it will be something simple that i will be overlooking...

Greatful thanks in advance

Cheers

Karl