Hello.

Please help me to seperate the following. All of these are the found in one worksheet.

On column K if found the word Received and Pending, the whole row will transfer to another sheet named Errors and Others.
On column Z and AA if found the word Error, the whole row will transfer to another sheet named Errors and Others.

Please help!

THanks in advance! :D