Searching multiple fields and then print the entire row from resul

  • Thread starter Thread starter Vegeta_matt18
  • Start date Start date
V

Vegeta_matt18

Does anyone know if it is possible to have say two fields where you can enter
search criteria to gain the results in a separate list?

Eg.

Animal Colour Name
Dog Brown Rob
Dog Black Fred
Cat Brown Phil
Cat Ginger Mark
Dog Brown Bill


If the search criteria was Dog and Brown I waould like the response to be as
below:

Animal Colour Name
Dog Brown Rob
Dog Brown Bill

Thanks in advance for any assistance :)
 
You might try going under Data - Filter, apply AutoFilter.
You can then use the drop-downs to limit your list to your particular
criteria.
 
Back
Top