Hi there.

I need a favor. I have an excel file which i use at work. I have lots of customers in there and i sort the customer names and add a new column and give them "ID Numbers" per each (The same names get the same ID's)

So Its ok to do this while the list is small but when the list is more then 100 rows then sometimes errors occur..

Is there a way for me to open a new column and make excel write Customer1, customer2 and so on? just like the example below. (with VB or not)


Thank you very much.

Sabi RAZON


John Person1
John Person1
John Person1
Sally Person2
Sally Person2
Andy Person3
Andy Person3
Paul Person4
John Person1
Sally Person2