Dependent Drop down list help

[wisemank]

Hi there,

I need to create a few dependent drop down lists driven from the results based on Customers.

Example:

Customers: Honda, Ford, GM, Vovlo, etc...

Honda Plants: HCM, HMIN, KTH,KSM, MAP
Honda Programs: Accord, Civic, CRV

Ford Plants: Monroe, Dearborn, LAP, KCAP
For Programs: V363, U152, U231

GM Plants: Lordstown, Ramos, Saltillo
GM Programs: D2XX, ND45, TX12

My first selection "Customer" then limits the selected "customer plants" and "Customer Programs"....

I cant seem to get the results i am looking for from: http://www.contextures.com/xlDataVal02.html

Ideas?

Thanks, Kip

 

[VBA Geek]

If you use tables then it is quite easy and dynamic.

Download Example

 

[wisemank]

The link has TSL security issues from where i am so I cannot download...