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