how do I filter a list of items based on values in another sheet

J

jumpsystems

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Using Drop Down list to an If Statement to another Drop Down list 3
Macro help?: move row to other sheet when text is entered in cell 0
Filter a Drop List ? 1
How to list cells from two sheets that has different values in theirneighboring column? 8
Change states of some checkboxes from drop-down list? 5
Filtering of data - autmatically based on data on other sheet 1
List of items from other sheets 2

Top