macro to validate data

I took a look but you would not really need macro's you could use conditional formatting to mark the empty cells that need to be filled.
The XYZ at the end of the names, where does that come from, I assume that the XYZ will stand for something else