I am currently running Excel 2003 in Windows XP. This is my question. I have a database of products I'm storing on a sheet named Database, which the user never sees. On another sheet call Input, I have four drop-down boxes which allows the user to:
Step 1. Select products filtered by one of four choices. I have done this simply using a Data Validation List.
Step 2. The second drop-down contains another Data Validation List which uses a series of nested IF statements to filter the choices available in the list based on what was chosen in Step One.
Now is when it gets complicated
Step 3. The third drop down should only display those products which are valid choices based on steps 1 and 2. There are too many choices to use nested if statements. I can successfully filter the information I need using an Advanced Filter, but I don't know how activate it. I want it to filter the list of choices in the third drop-down as soon as a choice has been selected from the second drop-down.
Step 4. Needs to do the same thing as Step three, but now filtered based on all three previous choices.
Any help would be greatly appreciated.
Step 1. Select products filtered by one of four choices. I have done this simply using a Data Validation List.
Step 2. The second drop-down contains another Data Validation List which uses a series of nested IF statements to filter the choices available in the list based on what was chosen in Step One.
Now is when it gets complicated
Step 3. The third drop down should only display those products which are valid choices based on steps 1 and 2. There are too many choices to use nested if statements. I can successfully filter the information I need using an Advanced Filter, but I don't know how activate it. I want it to filter the list of choices in the third drop-down as soon as a choice has been selected from the second drop-down.
Step 4. Needs to do the same thing as Step three, but now filtered based on all three previous choices.
Any help would be greatly appreciated.
