View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jumpsystems jumpsystems is offline
external usenet poster
 
Posts: 1
Default 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