Excel-PDF Image Split & Link
Budget: ₹600 – ₹1,500 INR
Link Excel Part Numbers to Spare Part Photos (PDF Extraction)
I have an Excel file containing a list of part numbers (around 1200+). I also have 5-7 PDF files that contain the photos of these spare parts.
What I need:
I want it set up so that whenever I click on a specific part number in my Excel file, the photo of that exact spare part opens up on my computer.
To achieve this, you will need to:
Extract all the individual spare part photos from the 5-7 PDFs.
Rename each extracted photo to perfectly match its corresponding Part Number in the Excel file.
Create working hyperlinks in the Excel file connecting each part number to its specific image.
I have an Excel file containing a list of part numbers (around 1200+). I also have 5-7 PDF files that contain the photos of these spare parts.
What I need:
I want it set up so that whenever I click on a specific part number in my Excel file, the photo of that exact spare part opens up on my computer.
To achieve this, you will need to:
Extract all the individual spare part photos from the 5-7 PDFs.
Rename each extracted photo to perfectly match its corresponding Part Number in the Excel file.
Create working hyperlinks in the Excel file connecting each part number to its specific image.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Microsoft Office
Image Processing
Adobe Acrobat
Data Management