How to equal two cells if they have different values

I have a database with some systems. I have made a marco that loop through the data and if they meet certain criteria are copied to differenct sheet. Something like this

Please Login or Register  to view this content.

My problem is that cell G2 might have the word "marine" and the cells N can have one of the words "all", "marine", "brackish". I want,for example, the word "marine" to be included in the word "all" so that the macro will select the system that have the word all if the criteria is marine.

I hope I explained it correctly.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Maybe like this

Please Login or Register  to view this content.

I am not sure if this is what I am looking. Maybe I didn't express it correctly. To make it more clear.
The cell G2 has the world "marine"
The cells in column N has one of these words: "marine", "all", "brackish"
For example N4="marine" , N5="all"
I want that if the code finds the word "all" to match it with criteria "marine"

Still not understand what you want,give sample workbook or picture
Maybe from this coding can you modifay

Please Login or Register  to view this content.

Here are images from my workbook
sheet1(database).PNG
sheet2(results).PNG

At sheet1 I have the database and at sheet2 I have the criteria. I want to paste from sheet1 to sheet2 the systems that meet these criteria. I have managed to do it with the numeric data but I have problem with the linguistic data because I want, for example, the world "marine" to be included in the world "all" and when the code finds the world "all" to select the system if the criteria is "marine".