Re: Excel Table Distillation
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.
Re: Excel Table Distillation
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
Code:
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.