Hi,
I have an excel worksheet.
In column A there is a list of numbers
A1 = "150"
A2 = "151"
In a folder on my C: drive there are photos. Each cell in column A should hyperlink to the corresponding photo on the C: drive. The problem is that the filename for the photo will not be an exact match to the cell.
cell A1 = "150"
photo filename = "150_Customer"
The values in the cell are always the first 3 values in the filename.
Excel needs to open the file based on the first 3 vaules only and ignore the rest of the filename.
Can anyone help me with this?
Bookmarks