Macro to match jpeg images to cell values

[eoghanmolloy]

I am sure there is a macro or a more time efficient way of preforming this task.

Each month I receive a new report that is over 10,000 rows in size. In column A, I have unique alphanumeric serial numbers. I am also given a separate folder with jpeg pictures relating to each row. Is there a way I can run a macro where it will create a hyperlink on each serial number and link it to the equivalent picture? The text by which each image is saved is identical to that of the values in column A.

Any help would be very much appreciated.

Thanks

[Marc L]

No need hyperlink by using double click event (if all files are in same folder) …

[xlbiznes]

Try something like this :

Please Login or Register  to view this content.

[eoghanmolloy]

Hi

Thanks for getting back. I had to stop running the macro as it was taking a long time to run through each row. Is there a quicker way of doing this?

Thanks