Hi,

I need help regarding linked or nested drop down values in excel.

I have three drop downs. First one is independent; second one depends on first one and third one depends on first and second.
The number of combination is 60000 so i cannot use some formula, need some VB code to do that.

here is the sample example

Column 1 Column 2 Column3
value1 value1value1 value1value1value1
value1 value1value2 value1value2value2
value1 value1value2 value1value2value3
value2 value2value1 value2value1value1
value2 value2value2 value2value2value2

I want to select distinct values. When user selects value in column 1, it shows corresponding values in column 2. When user selects column 2 then it show corresponding values in column 3

Will really appreciate the help if someone guide