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

On Wednesday, February 6, 2008 7:11:36 PM UTC+3, Dave Peterson wrote:
Using Data|Validation?

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

Mike wrote:

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