I currently use Excel as a design tool. While many of the normal equations, etc are obvious and easy to use, I cannot satisfactorily bring in a picture.
For example. I have 6 specific pictures that represent options on our product. In preparing the design and manufacturing spreadsheet, I will need to bring 1 picture on the main sheet. Pictures are contained on a page B. Depending on the PN entered for the product, I will want to select and place on the Page A a specific picture in a specific location on the page a. I know how to bring in a picture with the insert techniques, but I need a way to select only one picture and that is dependent upon the part number. I can deconstruct the part number without problem such that the PN represents one specific drawing.

For example: The PN is xxxxxxMA3. the A3 is one picture out of 6. the others may be A1, A2, B1, B2, B3, etc. I just want the one picture brought over, i.e.-the picture that shows what A3 option looks like.

So far I have not been able to find a way to bring just one picture over.

Any help would be appreciated.
Ted Von Kampen