Dynamically create drop down box when cell value changes
 

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

Dynamically create drop down box when cell value changes
 

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


"Mahesh" wrote:

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,
MaheshI

Dynamically create drop down box when cell value changes
 

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---
--
RyGuy


"Barb Reinhardt" wrote:

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


"Mahesh" wrote:

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,
MaheshI