i need to pull information from two columns and end of up with a customer number, VBA?

i have to pull the first four characters from a cell (has to be characters; must exclude dashes and "&" symbols) and also must sequence the results at the end with a "-1" or "-2" .... and so on; depending on how many times the first 4 numbers have recurred in the previous above cells, must decide if its a -1 or a -2, or -3......


ie ; A B C
ref # CUSTOMER ID customer name

33 BALL-1 Ball packaging europe
33 BALL-1 Ball packaging canada

IE#2

A B C
ref # CUSTOMER ID customer name

1 BALL-1 Ball packaging europe
234 BALL-2 Ball packaging canada

NOTICE THAT EVEN IF THE FIRST 4 LETTERS IN COLUMN C ARE THE SAME IF THE NUMBERS IN COLUMN A DONT MATCH THEN COLUMB B NEEDS TO COUNT UP



WHO CAN DO THIS I NEED TO ENTER 11,000 FILES BY HAND IF NO-ONE CAN HELP

PLEASE PLEASE HELP!!

I HAVE PICTURES IF YOU NEED THEM