drawings

I have an Excel 2016 worksheet that cangenerate thousands of possible part numbers that looks something like this==> 6 S1 F1 F1 E1 W1 Additionally, I have thousands of Pdf drawings in file folder G:\PDF with part numbers that looks something like this ==> 6 S1 F1 F1 E1 W1.pdf I’m looking to...

Hi, I currently have a 'parts' spreadsheet, in column 'A' I have recorded all of the part codes. In a folder on my drive I have the drawings to all of these parts. What I want to do is hyperlink the drawings to the part code in column 'A' of the spreadsheet, there are over 300 parts to this so...

Hi all, Could you please help with my below query. I am having a document register which contains transmittal number, document number submission date to the client, the status of the document, I need to find out the latest status of the document with latest date and approval code against each...

<tbody> 26-07-17 Minutes of Meeting AA/GADAG/HH/NH-63/2070/2017-18/100 29-07-17 Submission of Drawings in respect of Box Culverts and Retaining Walls AA/GADAG/HH/NH-63/2070/2017-18/102 26-07-17 Electrical Utility Shifting Bills AA/GADAG/HH/NH-63/2070/2017-18/99 08-08-17 Submission of...

I have a list of over 1000 drawings in one column and the building the drawings are associated with in another column. I have another list of drawings I am trying to match the right buildings to using a vlookup but the problem I am having some some drawings have multiple buildings associated to...