Searching multiple fields and then print the entire row from resul
 

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 :)

Searching multiple fields and then print the entire row from resul
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Vegeta_matt18" wrote:

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 :)

Searching multiple fields and then print the entire row from resul
 

Hi,

Kindly refer to the following link -
http://www.merawindows.com/Forums/ta...s/Default.aspx.
I have answered a similar question there.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Vegeta_matt18" wrote in message
...
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 :)