multiple drop down list that populates data

[acousticlife81]

Does anyone know a way that I can get data to populate from multiple drop down list that are dependent on each other. Here is an example of what I am trying to do.

Drop down list
Fruit-->Apple, Banana, Orange
Vegetable--> Carrot, Potato

Data Set:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Food Group
[/TD]
[TD]Food Type
[/TD]
[TD]qty
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Fruit
[/TD]
[TD]Apple
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Vegetable
[/TD]
[TD]Carrot
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Fruit
[/TD]
[TD]Orange
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Fruit
[/TD]
[TD]Apple
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Vegetable
[/TD]
[TD]Potato
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Now I need it to populate data from this list from a multiple dependent drop down list. The end result would look like this:

Fruit-->Apple -->qty

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Food Group
[/TD]
[TD]Food Type
[/TD]
[TD]qty
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Fruit
[/TD]
[TD]Apple
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Fruit
[/TD]
[TD]Apple
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you for taking the time to help.

-J

 

[mrmmickle1]

Debra Dalgleish has a good article on this subject. Please look here:

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