Dependent drop down from a single source list

**RandiLee** · 02-05-2016, 03:27 PM

I have a list of about 38,000 products from over 200 different vendors. I am trying to create dependent drop downs where if they select the vendor in one box, the second will be limited only to that vendors products. I know this can be done without VBA using the indirect function in the validation tool - if there is a separate list for each vendor. I need to avoid having to maintain over 200 separate lists.

There are a lot of other things going on in the workbook but I've created an abridged version of this issue and attached it for reference.Testing Dropdowns.xlsm

Is this possible with VBA? Any suggestions or thoughts would be much appreciated.

Thanks in advance.

**jaslake** · 02-05-2016, 04:54 PM

Hi RandiLee

Your Profile indicates Excel 2003 yet you've uploaded an xlsm File. Does the Code need to function in Excel 2003?

**Bernie Deitrick** · 02-05-2016, 04:57 PM

This requires that the list be sorted by vendor name.

I have used a name VList, with the definition:

=OFFSET(LkupArticles!$D$1,MATCH('Cell Site Equipment'!$C$4,LkupArticles!$H:$H,FALSE)-1,0,COUNTIF(LkupArticles!$H:$H,'Cell Site Equipment'!$C$4),1)

Here is a working version of your file.

Testing Dropdowns.xlsm

**RandiLee** · 02-05-2016, 07:47 PM

Sorry for the confusion, jaslake. Thanks for the heads up. I haven't been on here in a while. I'm using Office365. I'll make the update.

**RandiLee** · 02-05-2016, 07:49 PM

Bernie, That's exactly what I needed and simpler than I was expecting. Thanks so much! You're my hero!

Dependent drop down from a single source list

LinkBack

Thread Tools

Rate This Thread

Display

Dependent drop down from a single source list

Re: Dependent drop down from a single source list

Re: Dependent drop down from a single source list

Re: Dependent drop down from a single source list

Re: Dependent drop down from a single source list

Thread Information

Users Browsing this Thread

Similar Threads

Dependent Drop Down list to autofill next drop down with selective choices

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE

[SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list

[SOLVED] Removing blank cells from a dependent drop list in a single column

Dependent Validation List (Single)

[SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE (e.g. Blank)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions