Excel- Data Validation

[sumedha82]

Hey guys

I have drop-down list in Column 1 and based on my selection in Column 1, a new drop-down list appears in Column 2.

The problem I am facing is that if I change my selection in Column 1, Column 2 list does not change correspondingly. I am attaching my excel sheet for your reference.

Please suggest what could be the possibilities with/without using macro.

Thanks in advance

[jeffreybrown]

Hello & Welcome to the forum,

Take a look at the Test tab and cells F3 and G3. I did not want to change your setup, but instead, show you an example.

The named range used with G3 is MyChoices

[sumedha82]

Thank you very much Jeff for the prompt response. Let me describe my question in more detail.

So for Test Tab- The problem is that while I am changing my selection in Column F3, Column G3 doesnt get reset. It still shows the earlier selected values.

For eg. I select "Auto trip" in Column F3 and correspondingly "Auto 1" in Column G3. But then I decide to change my selection to "Air Train" in Column F3.

I wanted to check if there is a way that Column G3 gets reset to blank after my change in selection in Column F3 and doesnt show "Auto 1" anymore.

[jeffreybrown]

You will need vba to do this. Is that what you want?

[sumedha82]

Yes. I also think VBA it could be done with VBA but want sure.. I am not very good at VBA. Really appreciate if you could help me with this.

[jeffreybrown]

Attachment in post #2 updated with a worksheet event. To the code, right click on the first tab and view code.

[sumedha82]

You are awesome...Thank you very much Really appreciate the help.

[jeffreybrown]

You are very welcome and thanks for the feedback.