EXCEL HYPERLINK: Link JPG in folder via hyperlink
I am trying to figure out if I can link a .jpg
file with an Excel via hyperlink (or in another way).
Let me explain a bit more what I an trying to do:
Using Excel 2013:
- I have a folder with +1000 images, named by EAN code.
- I have an Excel file with all the EAN codes that I need an image of.
I would like to link each image with each cell in an extra column through a hyperlink.
Is this possible?
I have tried: =HYPERLINK("[Location pathway]\" & A1 & ".[filetype]","Click Here!")
I keep getting an error that it can't open the file.
Example below - I made a cell with the path and one with the file extension. Then I combined everything in another cell, like =path-cell & EAN-cell & file-type-cell
. In D column I set the Hyperlink.
You can, of course, hide the rows and columns that you don't need.