Need Macro Code to 'update' drop down list

I have been trying to find a solution to this, but since I can't code and have not much knowledge with excel Macros, I have come here for help!

So my problem is; I have a drop down list where one chooses what show they like. Then to the right, I have another drop down list (that uses =Indirect) to show what episodes are coming up.

The problem is that when the user picks their show, the second drop down menu (the coming up episodes) still shows the previous picked show's episode, although if you click on the drop down arrow - it will show the right ones.

What I want is for that 2nd drop down menu to automatically 'refresh', without having to click on the 2nd drop down menu. Is there a Macro someone can give me, or write that will make it do this?

Thanks in advance!

can you upload the sample file so that we can check your problem?

Regards
CA Mahaveer Somani

Sure.

I made a quick example one for you guys.

So basically I wanted the 2nd drop down menu to somehow 'refresh' its self, when I change the first one.

check the attached file with attached combobox in sheet2

if this help was useful to you then do not forget to hit * button for user reputation...

Regards
CA Mahaveer Somani

Originally Posted by mahaveersomani

check the attached file with attached combobox in sheet2

if this help was useful to you then do not forget to hit * button for user reputation...

Regards
CA Mahaveer Somani

Thanks for the help. Although is there a way to fix this issue without using comboboxes? Since my main project is using data validation drop down lists throughout.

i dont think so there will be another way...if it exist (excel ninja) then forgive me...

if helped then do not forget to hit * button for user reputation..
Regards
CA Mahaveer Somani