Search result in New Tab with Filter

[tigerrr]

Hi, I have a long list of details in Sheet2. I would like to have a search function in Sheet1, and it is automatically filter the result in Sheet2. Is that possible?

For example Category A, in sheet2 it will auto show only Category A.

And example Colour Black, in sheet2 it will only show colour black.

[Pete_UK]

A slightly different approach is to set your search parameters in Sheet1, and then the appropriate data appears on that sheet, by copying across the data that matches - Sheet2 is unaffected.

This could be done using a few formulae.

Hope this helps.

Pete