Thank you Mr. Science. But we have to add some code to this.
Instead of deleting the entire row (myName.EntireRow.Delete), we have
to look up Column H for A or B. If there is only one A, then delete the
other column. If both are A, look up Column G and delete the oldest
data (we have to check the latest date).

Thanks in advance for any addition.

-Dileep