I have a multiple cells (C1, E1, G1, and I1) that each has the same list(done through Data Validation). I want to have the cell underneath (C2, E2, G2, I2) to insert a picture based on the value selected. For instance if C1=apple I want a picture of an apple to appear in C2, E1=orange then a picture of an orange will appear in E2, etc. I have a spreadsheet "Pictures" that has 2 columns one column with the names for my list and another with the pictures (formatted to fit the appropriate cell). I also have each picture saved on my computer if that helps.
I have Excel 2007.
Bookmarks