Hi,
I need a way that when I select a value from a drop down list a picture will generate in the cell below based on the answer.
I understand how to do this part but my problem is I need it to happen in around 2-300 columns.
I have a sample attached but when i click the option it changes the images in all columns instead of just the column i want.
So in my example if I change A2 I want the image in A3 to change but nothing happen in B. Then when i change the image in B2, B3 will change and Column A will be unaffected.
Is there a way to fix this?
Thanks
Bookmarks