Hello all, and thank you in advance for any assistance you may be able to provide.

I work for an engineering company and one of the things we do is have a list on an excel spread sheet of the engineering drawings we create and note down when and who we issue them to. We make these drawing registers up and they have a description of what the drawing is and the drawing number. The problem is I would like to start and put hyper links into the drawing register excel spread sheet but for each project there are at least 30-40 drawings! Is there any way of finding the corresponding drawing file from the drawing number in the spread sheet and get it to automatically create a hyperlink to it?
And even more importantly is there a way to do this for multiple drawings?

An example of this would be we have a drawing referenced as 5000 in the excel sheet and it is also referenced as 5000 in the drawing folder. I would like to find/create a macro or something like this to create a hyperlink in the excel sheet for drawing number 5000, 5001, 5002 and so on.

Thanks for taking a look,

Regards,

Simon.