I have been searching the web and have been unsuccessful to find the CALC solution. Excel is every where with the paste picture list…
When a Validity Cell picks a text value from a dropdown, I want an image to show up.
I have studied this site and see his works, but have been unable to duplicate. can someone create a step by step or a video with just 2 images and 2 dropdown names all on the same worksheet? Is a macro the only way?
I see this Macro example does not work on just one sheet, needs the second for indexing.
I also see this concept is from 2013. I am sure someone has come up with something better. Also thanks for your response.