This time I have come with a new problem. I wanted to give thanks first for your replies of my earlier queries and hoping the same for this time as well.
What I want is through my C# program I can add 3 dropdowns in excel (Country, State, District), till here it goes well but then I want a filer if I select a country from country dropdown it should filter next State dropdown with only those states which are belong to selected country and then same for district for selected state.
There are only selected countries are there in the dropdown based on my business I get those countries and then states and districts. I am able to fill all selected countries, states and districts in dropdown but not able to filter them.
How can I do that through C# or is there any way in excel by which I can achieve this.
Quick help will be appreciated.
What I want is through my C# program I can add 3 dropdowns in excel (Country, State, District), till here it goes well but then I want a filer if I select a country from country dropdown it should filter next State dropdown with only those states which are belong to selected country and then same for district for selected state.
There are only selected countries are there in the dropdown based on my business I get those countries and then states and districts. I am able to fill all selected countries, states and districts in dropdown but not able to filter them.
How can I do that through C# or is there any way in excel by which I can achieve this.
Quick help will be appreciated.