I have a listing of some 10,000 customer enquiries (this list changes every week), I need to distribute these to my 7 employees based on the first letter of the customer name.

I have taken the list every week, sorted it in alpha order, then copied the clerks name assigned to the first letter. (a long an boring task)

I have used the "Left" function to break out the first letter, but now want to make a macro to automaticly enter in the right staff members name based on the first letter of the last name.

A = Sally; B = Jane; C - Sally; E = Jill; F = Jane; etc, etc.

I know that this can be easily done in a VBA macro, but I am too close to the problem to see the obvious solution. If anyone has a VBA macro they have used for this type of situation, I would love to see it.