Hi,

I'm trying to create a report page for a table of information kept in another spreadsheet.
I have managed to select the data by use of a validated list and VLOOKUP.

I would now like to embed a pdf document and a couple of photos into the report (as images, not hyperlinks as the report page needs to be printable)

The links to the data are kept in the table with the results but I'm struggling to pull this information from the table to update the embedded images.

Can this be done using excel/VBA?

Many thanks,

Mark