Hello,

This is my first post as honestly I do not know where else to go to for help. I am decently skilled with Excel (as required by my job), and one of the projects I have undertaken is to compile a list of historical transactions my firm has been engaged in. For each transaction completed though, there is marketing material that corresponds to the transaction, specifically an image. We are trying to host the images on an intranet site, but there has been some issues.

My end goal is to have a database that has links to the website, and when someone clicks on the link within the Excel database, I am trying to figure out a way to bring the image into the Excel file so the individual does not have to open a browser to accomplish this (I know logically it isn't the most sound practice, but this is not by my request). Further, doing so requires logging on to a VPN as the intranet is secure. Further, since the website is constantly updated, when a refresh of some information occurs in Excel, it is not always in the same format and I have to use a maddening combination of indirect formulas and the like to make sure it is consistent.

Long story short, is there a way to click a link or utilize a prompt/form in excel and the result brings an image into the file?

Sorry for the long post. Thank you so much.