Excel Table Distillation

[googull]

I have a large table in Excel that I need to filter on 3 times. I'd like to use a series of combo boxes or cell validation on 3 cells to distill the data. First cell only displays the unique items in column1 of the table. Second cell then the items from col21 that qualified after the first pass. Third cell then does the same for criteria set by first two reductions. Very much an autofilter type application but I don't want the user in the table at all. I've written some knarly code to do this by brute force into a series of three combo boxes. I am wondering now if there is a more elegant way to approach this problem perhaps allowing direct entry into cells using validation (or other) without having to write the brute force matrix searches.

[RobDog888]

Couldnt you just programmatically autofilter on three colums so you get the same results? Is that not whats being asked? Record a macro doing your autofilter and view the generated code in the module.

[googull]

I looked at the generated code but wasn't sure how to attach the table results dynamically to a cell to allow the next selection. I'll be more specific in my intent...

Table has 12 columns. I will be searching for a specific row based on three column lookups as required to uniquely select a row. I want to present the lookups as combo boxes or better as cell-validation-lists on another worksheet. So in my case col1 is Product, col2 is width, and col3 is height.

Sample Table

Col1   Col2   Col3
PA      10      40
PA      10      50
PA      10      60
PA      20      40
PB      10      30
PB      10      35

On my user worksheet I have three cells or comboboxes all empty. They must be selected in order as the data must filter properly based on prior picks. So when user

CellA needs to present pick list with PA, PB.
if PA is selected then CellB needs to present pick list 10,20
If 10 is selected then CellC needs to present pick list 40,50,60.
If 50 is selected, I need a handle on the row uniquely selected from this process to extract data from the remaining columns (not shown in this example).

Like I said I wrote a bunch of search and sort routines to do this the hard way but find I am need to do this more and more and would like to figure out how to leverage some of the high powered commands to work this reduction process more elegantly.