Automate cells data

Good morning everyone!

I have a spreadsheet that I need one thing automated on it (for now). It is a tracking sheet for our QA coordinators. What happens is they have a list of medical charts that are incomplete, when they mark the column complete with an "x" then the cell that contains and "x" under the Team Leaders name should disappear.

I have a code similar but I don't know who to use and array in the code.

This is what I used to change the date of a fields automatically (I recieved this from someone on line here)

 If Target.Cells.Count = 1 And Target.Column = 14 Then

Range("p" & Target.Row) = Date

I have attached a spreadsheet for you to check out.

Any help would be appreciated!

Larry