Dynamically create drop down box when cell value changes

[Mahesh]

Hi I am trying to create a Excel file that will be used by users to input
data. I want to put some validation so that they enter correct data.
the excel contains:
Col1 Col 2 Col 3

Col 1 & Col 2 are drop down list.

Now I want to change the drop down values of Col2 based on the value that is
selected on Col 1

Ans also, when ever the Col 1 is changed again the already selected values
on Col2 , Col 3 should be erased.

Please advice.

Thanks,
Mahesh

 

[Barb Reinhardt]

I think you're looking for Dependent lists. Debra Dalgleish has some info
here on those

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

HTH,
Barb Reinhardt

 

[ryguy7272]

Right, or look at this:
http://www.contextures.com/xlDataVal13.html

If that still doesn't answer your question, look at the bottom of the page
for about 14 related tutorials


Ryan---