Embedded objects query- Help Required!
Hi, I'm wondering if anyone can help me. I have a list of embedded PDF files within a table but I would like to return a specific embedded file based on a cell value. For example I have an embedded PDF for Product 1 in the table which I would like to be pulled through on a summary tab when product 1 is selected from a data validation list. Is this possible? I know it is possible with a vlookup when using hyperlinks to files, however unfortunately I cannot use hyperlinks in this scenario as this file will be going out externally. Any help and suggestions would be appreciated. thanks in advance Luke
