| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I filter a list of items based on values in another sheet
I have a workbook with two sheets. Sheet 1 contains a list of projects and
various criteria, Sheet 2 contains a reduced view of the first driven by a drop-down list. The drop-down is using values that are stored in sheet 1 and, when a value is selected, I want to filter the results into Sheet 2. I've tried variations on Autofilter and Advanced Filter plus Lists but without success. Any ideas? -- David Jump Systems Ltd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter 10 items from a list of 100 | Excel Discussion (Misc queries) | |||
| Filter Range on Sheet B Based on List on Sheet A | Excel Discussion (Misc queries) | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| Filter based on a column of items | Excel Discussion (Misc queries) | |||
| Can I format a cell in excel based on a list of about 20 items? | Excel Discussion (Misc queries) | |||
Threaded Mode
