Hey all,
I deal with several forms that have client specific information on them. I have automated them as much as possible with VLOOKUP. The one form that I have that does not have any images to put on it is simple, put in the key and the form auto fills. Many of my other forms have images that are specific to clients and contracts that need to be called into each sheet as well. So far I have had to save each one as a separate file as I go so that we can see it later.
What I would like to do is to automate these sheets as well by putting all of the information on a master list and calling in images, which could be saved elsewhere, into the specific space on the form. Is there any way to do that?