Variable Drop Down List

[masonbp2]

Hello,

I am looking to create a variable drop down list that shows the products sold based off of a customer that is selected. For example, if I select customer A, I want the drop down list to show products A, B, C and D that are sold to that customer. However, when I select customer B I only want the drop down list to show products C and D that are sold to that customer. I cannot use a simple indirect reference to a named range based off of the customer, as there are over 700 customers and I don't want to make 700 named ranges. If anyone could think of a better way to solve this problem I would greatly appreciate it.

Thanks

 

[Fluff]

It can be done with vba if you're interested