Automating Cel Population of .jpg

[skoz55]

I am attempting to create a workbook that will populate cells with .jpg pictures based on the selection in another worksheet.

I have clients that choose items to purchse from a selection of 20, and there are 10 of the these categories. Thus 200 .jpgs Currently, my clients fill out a sheet by hand, I then place the .jpgs in a Word document based on what they selected. I would like to send them an excel spreadsheet that has 10 drop down menus. These lists contain the 20 items.

As they select the item, the corresponding .jpg is inserted on another worksheet in a cell. I can then print one page that has all of the pictures of what they picked out.

I've been messing around with if then statements, however can not associate the .jpg. Ideally, all the picture files will be on another worksheet so that everything stays together in one workbook.



Thanks