Hi I have created a 2500+ line excel sheet with a hyperlink to photo's in files in same folder.
I have created a (Front Cover) using look ups on the next tab and would like to show the correct photo each record as it is changed.

I show the hyperlink in cell "R3" and would like the photo in cells "J8:N21"

I have tried various VBA's from the web but none work

Any help would surely be great-fully accepted

Unhappyharry