Script for Google Spreadsheets

Good day.

Need to develop a script for a Google spreadsheet of this type
3. Take the values with columns Name and Email do not have tagging Failed or NOT, and copied to a separate worksheet of the same document in columns with the same named