Respected Sirs,

Im new to VB :( and desperately in need of this.

I need to distribute loans that are received from different states among agents, in such a way that no single agent receives only one state loan, but the loans(per state) are distributed among all. In case the loans(of a particular state) are lesser than the number of agents, then the loans must be distributed to the agents first in que.

I need a code that will first sort the data as per state code and then distribute each state loans among agents that are specified in the list, in each agents individual sheet. It should also insert the agents name in the master sheet to whom they are assigned.
I should also be able to change the agents names in the list, i.e.. Then names of agents should not be fixed in the vb code.

Thanking in advance. Appreciate your help.

I suppose I could figure all of this out, but it would take more time than I have allocated. Could you give me an example of exactly how you might distribute the loans? (I downloaded your attachment and examined it, but it's not obvious what the requirements are).

You can sort within Excel. You don't need Visual Basic (or VBA).

I suppose I could figure all of this out, but it would take more time than I have allocated. Could you give me an example of exactly how you might distribute the loans? (I downloaded your attachment and examined it, but it's not obvious what the requirements are).

You can sort within Excel. You don't need Visual Basic (or VBA).

Dear Sir,

Have added my comments in the attachment itself column 'O' Please check and let me know in case if it is possible.

Thanks Mike.