Looping through column and changing duplicate values

I have a list of employees in column A with performance stats in the remaining columns. However, some agents have the same name and there is no way to distinguish them. I'm trying to get a VBA code that will add a 1 to the end of the first duplicate's name, add a 2 to the end of the second duplicate's name, etc.

Current:

Col A
Andy
Becky
Becky
David
David
Eric
Herman

Desired:

Col A
Andy
Becky1
Becky2
David1
David2
Eric
Herman

I hope I've explained my issue adequately. It seems simple enough but I can't figure it out. Any help or guidance is appreciated.