Drop down list

S

Sonny

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
look up formula 3
Excel Help: Keeping Data 1
Drop-Down List 3
Drop Down List 3
Drop down lists 1
Building a Matrix 4
Drop Down List 4

Top