Thread: Searching
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seb Warmoth[_2_] Seb Warmoth[_2_] is offline
external usenet poster
 
Posts: 9
Default Searching

Is there a way to have a selection of boxes each titled with a column in a
second sheet and then filter based on these. Basically, if someone types a
name in the box representing column C, is there a way to then go to the 2nd
sheet and see a pre-filtered sheet. Can this be done with multiple inputs to
filter it even more, such as a name in column C and a job in column D to get
a more defined search? Thanks