I have been using vlookups for ages to create 'dynamic' pages, ie you
select the product/shop it gives you the data in a page for that
place. I have been asked if I can include pictures....

Is this possible. If the Photos are in a common name format ie c/my
pics/shop 1 etc can there be some VBA code that will pull this from
the folder and insert.

Thanks

Matthew