Data Validation Inseption - 3 Layers Deep Dependant Unique Lists

[CamB]

Hello all,

I've been charged at work with speeding up some spreadsheet creation via using data validation lists. I've been trying different things for the past few days and have hit a wall.

Lets say we have 3 lists; Plant Classification, Name, Sub Species.

Some mockup data would look like. Not really the data I would be using but once i have the process down I can adapt it.

Excel Workbook
	A	B	C
1	Plant Classification	Name	Sub Species
2	Fruit	Apple	Granny Smith
3	Fruit	Apple	Red Delicious
4	Fruit	Watermelon	Black Seed
5	Fruit	Watermelon	Seedless
6	Vegetable	Potato	Golden Brown
7	Vegetable	Potato	Pink eye
8	Vegetable	Carrot	Juicing
9	Vegetable	Carrot	Eating
Sheet3

Ultimately what I would like is for on a separate sheet to have a data validation drop down with just the three columns with each only showing unique values and being dependent on the previous value.

I've been told I cannot use VBA to do this as some clients have had issues with macro enabled workbooks in the past.

I've gotten as far as doing one unique list. But am stuck at the second.

It would be fine if the data was static but the client needs to change/modify and add new data.

Any help would be greatly appreciated.

 

[grizz]

check out this site --- very good examples -- if it doesnt help let me know
https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/files

 

[jeffreybrown]

Hello & Welcome to the Board,

Did you download the sample workbook?

One you create the first validation list, in B1 you would create your second validation but instead of a list as the source you would enter =INDIRECT(A1)

When it comes to more than two data validation lists it gets a little more tricky, but if you look here http://www.contextures.com/xlDataVal15.html this will go you going in the right direction.

There is a sample file there also.