Conditional Drop Down
In the attached excel file there are list of names and list of cities. If I select city as "DELHI" for "A", I should not get "DELHI" in subsequent drop downs. Means next drop downs should show only remaining cities. Please help me on this.
|