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

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