drawings

  1. R

    Link lookups to corresponding PDFs

    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...
  2. B

    Hyperlink via VBA

    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...
  3. V

    latest status with against dates

    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...
  4. B

    Hyperlink and sorting my list?

    <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...
  5. Z

    vlookup with multiple instances

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top