HELLO,

i HAVE A DATA THAT LOOKS LIKE THIS,

10199751
10199751
10199751
10199760
10199760
10199765
10199765
10199765
10199765
10199765
10199765
10199765
10199765
10199777
10199777
10199777
10199777
10199777
10199777
10199777
10199777
10199780
10199780
10199780
10199780
10199780
10199780
10199780
10199789
10199789
10199798
10199798


THE RESULT I WANT IS

10199751 1
10199751 2
10199751 3
10199760 1
10199760 2
10199765 1
10199765 2
10199765 3
10199765 4
10199765 5
10199765 6
10199765 7
10199765 8
10199777 1
10199777 2
10199777 3
10199777 4
10199777 5
10199777 6
10199777 7
10199777 8
10199780 1
10199780 2
10199780 3
10199780 4
10199780 5
10199780 6
10199780 7
10199789 1
10199789 2
10199798 3
10199798 4


LIKE THIS I HAVE SOME 40,000 FILES AND I NEED TO NUMBER THEM AUTOMATICALLY.......BASED ON THE "A" COLUMN................HOPE SOMEONE HELPS ME WITH A MACRO

THANKS