Thread: Drop down list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sonny Sonny is offline
external usenet poster
 
Posts: 9
Default Drop down list

I want to create two drop down boxes that are depending on each other.
For example I have a datasheet with fields like (customers,date,SKUs). I
want to be able to create a drop down list based on Customer Name and another
drop down based on SKU's. If I choose Customer A, the second drop down only
allows the SKU's for that customer and vice versa, If I select a SKU, I only
want Customers with that SKU in the other drop down list.

Any help will be appreciated.

Thanks in advance!