I have an excel sheet with the following values

A B
1 1a
1 1b
2 2a
2 2b
3 3a


Now if i try to enter a value in an empty cell...i should get a
dropdown containing the distinct values from the column -A....and when
a value is selected..then when i try to enter a new value in the next
cell i should get a dropdownlist containing the values in column
B..but the one that are related to column A only

ie if i select 1 then the next cell should have only 1a and 1b

See http://www.contextures.com/xlDataVal03.html

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kalyan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an excel sheet with the following values
>
> A B
> 1 1a
> 1 1b
> 2 2a
> 2 2b
> 3 3a
>
>
> Now if i try to enter a value in an empty cell...i should get a
> dropdown containing the distinct values from the column -A....and when
> a value is selected..then when i try to enter a new value in the next
> cell i should get a dropdownlist containing the values in column
> B..but the one that are related to column A only
>
> ie if i select 1 then the next cell should have only 1a and 1b
>