please help me with filtering function

Hey everyone! I really need some help/guidance.
This is my objective, I’m not sure if I need a function or filter or macro, anyway here’s my situation.
I have an excel spreadsheet that is being updated with data every day. For explanations sake I’m going to call the “script/action” command X.
I need to be able run command X on the daily updated spreadsheet.
This command X would need to do the following.
Start Loop
Search through column E
Find string “Thank You” (in column E) -1st criteria
and
Find string “Transfer” (in column E) – 2nd criteria
Once string “Transfer” is found
Then Copy Data in Row (A-E) (same row “transfer” was found”)
Paste data into new spreadsheet, spreadsheet_transfer.xls
Repeat from top to bottom of spreadsheet (row 1 to row n)
I can edit it and add my 2nd condition of criteria.
Which would be 1-“Thank You” and 2-“Hang Up”
To spreadsheet_hungup.xls
This way I’ll be able to run this “command X” to filter and copy the data based on the conditions.
I would really appreciate if someone could help me out with this. I’m in desperate need, and I’ve been struggling for long days.






This is the new one-2.xlsm

This is really good but my data is a lot bigger than the example and the criteria that I am looking for is longer text than just Thank You. how can I change that?

Should I go to macro and change it or how to remove the protection on the sheet so I be able to type something else instead of Thank You and it can filter it

Thanks for your help

The advance filter finds just Transfer or Hang up and sort them but I need it to find Thank you first and then filter and sort Transfer and Hang up.

in the original file there in many Transfer and Hang up but not all of them comes after the thank you.

Please help me to find a way to search and filter them

You are absolutly correct.
but if I need a macro or formula to find Thank You first... then sort the Transfer or Hang Up to different sheets.

There is other hang up on the sheet that I don't need. I only need the ones that has Thank you before them, if you take close look, they would have different file numbers. some files has thank you and hang up and some has thank you and transfer.

The ones that has just hang up or transfer is not what I look for.
I hope this explain it little better.

Yes there are more tests between Thank You and Transfer or Thank You and Hang Up.
The way you offered me was great but it finds the entire hang up without checking the Thank You first. Both criteria needs to work at the same time

Start Loop
Search through column E
Find string “Thank You” (in column E) -1st criteria
and
Find string “Transfer” (in column E) – 2nd criteria
Once string “Transfer” is found
Then Copy Data in Row (A-E) (same row “transfer” was found”)

Thanks for your help but you changed what I asked for. I need a macro to look for two criteria in two different cells in the same column. you took both of criteria from two different cells and enter it in one. would you please just give me a macro that look for two different criteria Thank You and Transfer in two different cell in one column (E). Thanks