I need a macro code for this please.
Here’s the scenario. Column A cells has 4 default entries AA, BB,CC,DD which I made it as a dropdown list. By default these 4 entries represents corresponding numbers AA=1, BB=2, CC=3, DD=4. What I need is once I click certain cell for example A3 and select BB, B3’s value should be “2”. What is the best statement? If or case. Post code please.
Thanks in advance,