Drop Down Boxed where each list is based on value in previous drop down box

Dear users,

I'm struggling to find an awnser to what i'm looking for.
I have on one settings sheet with a query tabel from a database 5 columns of budget data which look like this (total of like 500 rows). These rows could change every month:

Customer product Condition Sales Budget
BAS NPC COOP 1000 10
BAS NPC REBATE 1000 10
BAS MON COOP 500 50
ACT NPC REBATE 2000 20
ACT MON COOP 5000 50

And so on.

In another sheet: "the model" i have these same headers for which i want to create drop down boxes.
First the user selects incell A1 a customer (no duplicates should be allowed). Then the user should select in B1 the product that this customer has.
Third in C1 the condition is choosen. The fourth and Fith action should be automatically and in D1 en E1 the sales and budget should be shown.

These drop down boxes should only appear after the row has been activated, so by some kind of macro. After the data has been filled in the drop down box should be deleted and only the selected values should stay.

Can anyone give me a hint as how to do this? I've tried to find solutions but i'm not sure any are applicable to my desires.

Kind Regards,

John

Hi,

It sounds like you may need the Data Filter Advanced functionality where the criteria cells are drop down values. Check this functionality first and if it's not giving you what you want, post back and attach an example workbook.

Regards