drop down values based on the another drop down

[Gupta]

There are two drop down columns A & B, I want the drop down values of
to be displayed based on the value selected for A

 

[Roger Govier]

Hi Gupta

take a look at Debra Dalgleish's site for detailed examples of how to
achieve this.
http://www.contextures.com/xlDataVal01.html

Regards

Roger Govier