Hi

Look at this site:

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

Regards,
Per

"Mikej" skrev i meddelelsen
...
Hi,

I am trying to implement multiple cascading drop down lists. I have two
worksheets: a user one (with the dropdown lists and data tobe displayed)
and
a master one (with variables and data).

on the master sheet, variables may be identical in a column but
combination
of all variables in a row is unique.

Here's an example of my data worksheet (I use non standard characters and
spaces in each column)

var1 var2 var3 data1 data2 data3
A AA AAA 1 2 3
A AA BBB 4 5 6
A BB AAA 7 8 9
B BB AAA 10 11 12
B BB BBB 13 14 15
C AA CCC 16 17 18
C CC CCC 19 20 21

displaying the data on the user sheet works fine using basic data
validation
and DGET as long as I know what to selet from the lists. I'd like to be
able
to select var1(showing unique entries) for var2 to show me unique entries
dependent on var1 and so on.

in the end i will have over 6 variables to work with but that shouldn't
make
any difference.

Thanks for any help.