Dependent List Box

[KARWAN]

Hi I am trying to create dependent list box, But so far not getting the idea. Any one here for my rescue.

I have a table in which first first column is brand manager name and another one Brand belonging to the manager.
In First List box the User will select the Brand Manager.
In the Second list will user will select the brand.
What I want is when a user select the Brand Manager from the first list box, the other list box should display only the brand belonging to Brand Manager.

I am attaching a dummy excel file. Please help me

 

[Asheesh]

Check the below links...

http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/

http://chandoo.org/wp/2014/02/25/robust-dynamic-cascading-dropdowns-without-vba/

http://chandoo.org/wp/2008/11/25/advanced-data-validation-techniques-in-excel-spreadcheats/

 

[Syedali]

Pfa