Finding key words in a list and putting them to another sheet

[nova_sweet]

Hello!
I would like to have the possibility to 'filter/sort'? a list with 5 columns after key words. When I search for 'xyz' all row where 'xyz' is in one column should be transferred to another sheet which I then can print out.
How can I do that? Thankful for any help/suggestion.
Best regards

 

[Taul]

Hi,
It sounds like you need the Advanced Filter.
There is a good tutorial on the Contextures website Excel Advanced Filter Introduction
and also a sample workbook to download.

If you set up the Criteria for "OR" by having the criteria text under each column heading but on separate rows. You will see what I mean if you have a read of the tutorial.
Use this as the text that you are trying to find ="=xyz"
The result of the advanced filter can be in place or on a separate worksheet.

cheers
Paul

 

[Taul]

slight correction, as your xyz text may be mixed up with other text, the criteria should include a wild card.
so the criteria becomes ="=*xyz*"

cheers
Paul.

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

It would also be good to see a small set of dummy sample data and the expected results with XL2BB

 

[mikerickson]

slight correction, as your xyz text may be mixed up with other text, the criteria should include a wild card.
so the criteria becomes ="=*xyz*"

cheers
Paul.

Fun fact, without the = sign, Advance Filter criteria assume a trailing wildcard

xyz will find "xyz smith" but not "tom xyz" but *xyz will find both.