There are instructions here for dependent data validation lists:

http://www.contextures.com/xlDataVal02.html


Shekhar Gupta wrote:
I have entered a list validation in 1 column, and want another list
validation in the adjacent column based on what I select in the 1st list.

Please help

Shekhar


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html