Hey everyone,

I'm a complete noob at VBA Code so I need some guidance to optimize and clean some unwanted data in a sheet that I have.

My sheet is something like this:

Name Adress Email Phone Code Code Name
Oliver Jacob Russia OliverRussia @ hisISP.com 356 555 983 083 Designer
Jack Ethan Germany JackGermany@hisISP.com 356555985 085 Engineer
Harry Michael Turkey HarryTurkey@hisISP.com 356555982 081 Accounting
Alfie Jayden France AlfieFrance@hisISP.com 356-555-984 Engineer Engineer
Charlie William United Kingdom CharlieUnited@hisISP.com 356555981 085 Engineer
William Noah Ukraine WilliamUkraine@hisISP.com 356555980 X X
Alfie Jayden France AlfieFrance@hisISP.com 356-555-984 Engineer Engineer
Jack Ethan Germany JackGermany@hisISP.com 356555985 085 Engineer

I need some bits of separate VBA code that detect some situations and tag them. (-Maybe in the column after the last one put a X mark so I can use a filter confirm each situation-)

-> Detect identical rows (all columns). - In RED
-> Detect empty rows (all columns).
-> Detect if some number isn't in 55555555 format /a email in name@ISP.com format / A code (specific clumns). - In GREEN


Thanks in advance,