I have a list of Part Numbers that is 400+ parts long. I have pictures corresponding to each part number. I have a macro that searches for the numbers in the first row and opens the link in the 3rd. I want to copy the number in the first row and create a link to the picture that has the same file name as a .jpg. The numbers are not sequencial and I included a short sample of the number I'm working with to give you an idea.

35214 ...