EXCEL: Display images from folder based on cell value (multiple lists)
Budget: $30 – $250 AUD
I have an excel file that I built that needs only one input - A Part Code from a drop down values. Then all cells are filled up with information about the Part. This is completed.
My problem is
1. How to display the images of the list of spare parts/components of the Part dynamically everytime the Part Code is changed (Unique image for every part or component in a list)
2. How to get a preview of the assembled Part (in PDF) every time a new input for Part Code is entered.
I started to build the excel file with a macro (VBA) but I can't make it work.
My problem is
1. How to display the images of the list of spare parts/components of the Part dynamically everytime the Part Code is changed (Unique image for every part or component in a list)
2. How to get a preview of the assembled Part (in PDF) every time a new input for Part Code is entered.
I started to build the excel file with a macro (VBA) but I can't make it work.