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
Bookmarks