Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use list of criteria in filter
I have several related sets of data. Any idea how to arrange the macro in
filter following? Now I have a validation list to select value from Row 1 to 3. Let say Row 6 to 8 are branches of Row 1, Row 10 & 11 are branches of Row 2 and so on (the number of row in subordinate data are not same). What I am looking for is when users pick a name in the validation list say AAA, macro gets the criteria of 111, 222, 333 and use them to filter out non related data. Column A Column B Row 1 AAA Row 6 111 Row 7 222 Row 8 333 Row 2 BBB Row 10 444 Row 11 555 Row 3 CCC Row 14 666 Row 15 777 Row 16 888 Row 17 999 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Filter criteria | Excel Discussion (Misc queries) | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |