dependent drop down lists

[scorry]

Hi guys
Kindly help me in coming up with dependent drop down lists in excel 2007 and how do u link them such that if u pick on an item on a list e.g vehicle model A then u realize you picked the wrong one and u actually wanted vehicle B, when u click on vehicle B it clears out your previous selection.

thank u

[:) Sixthsense :)]

Refer the below links for detailed instructions:-

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

[scorry]

thank you sixth sense..very helpful.