Excel 2003 - Drop Down list based on another cell value

[Mike]

I have one cell with a drop down list, when the user chooses the value they
need, I would like another cell populate a list based on their choice, how is
this possible?

 

[Dave Peterson]

Using Data|Validation?

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

 

[Mike]

Thank you, it worked.

Using Data|Validation?

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

 

[subrothob]

How do i get a drop down list in cell C1 depending on text value in A1 and when the A1 value is changed , the drop down cell C1 becomes normal cell???
please help