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!

Drop down list
 

hi
what kind of drop down list????
combo box?
data validation?
assuming you are using DV, see this site...
http://www.contextures.com/xlDataVal02.html
http://www.contextures.on.ca/xlDataVal10.html

regards
FSt1

regards
FSt1

"Sonny" wrote:

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!