| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create list of selected criteria in auto-filter range
I have a table in Range B3:H1000, with row 3 containing the headers &
autofilter. In a separate table, I would like to capture the filter criteria selected by the user for each of these 7 columns. For example, if the user chooses "Apples", "Bananas", and "Pears" in column B, there may be multiple records for each of these. I would like the table to capture each of these unique values only once. Same for column C - H values. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Separate Button for Auto Filter Selected Range | New Users to Excel | |||
| No. of rows selected from auto filter not visible on toolbar? | Excel Discussion (Misc queries) | |||
| How do I obtain total for auto filter value selected ? | Excel Discussion (Misc queries) | |||
| Auto Filter Delete Rows by Criteria Doesn't Work Range To Complicated | Excel Programming | |||
Threaded Mode
