Distribution list

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.

Sigh.. it is always the easiest answers that make it work. Now to imbed this into the VBA macro.

Thank you very much for looking at this and making the obvious suggestion!

Much appreciated