Searching multiple fields and then print the entire row from resul

[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

 

[Luke M]

You might try going under Data - Filter, apply AutoFilter.
You can then use the drop-downs to limit your list to your particular
criteria.

 

[Ashish Mathur]

Hi,

Kindly refer to the following link -
http://www.merawindows.com/Forums/tabid/324/forumid/90/threadid/43323/scope/posts/Default.aspx.
I have answered a similar question there.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com