auto assign project

[newbie_010108]

Hi, im using excel 2003. Would like to build a macro where in this will auto
assign workloads to the analysts according to their current workloads. The
idea is whoever analysts has the least # of provs in his current workloads
will be assigned a new workload base on the new inventory. All the request id
who has the biggest number of "days on hand" should assign first.
Here is the data:

--new inventory sheet--
New request id days on hand # of provs assign to

1 11 2
2 11 2
3 11 1
4 10 1
5 10 3
6 10 1
7 9 1
8 9 1
9 9 2
10 8 2
11 8 1
12 8 1
13 8 5
14 7 3
15 7 1
16 7 1

---current workloads of the analysts--- there are total of 5 analysts

analysts # of providers
Karen 3
Ferdy 5
Analyn 11
Leo 2
Edison 1

Base on the current workloads Edison has the least # of providers, so the
request id 1 should assign to him, now he will have a total of 3 providers.
So next request id 2 should assign to Leo because he has only 2 providers on
his inventory, now he will have 4 providers. Next request id 3 should assign
to Karen, which will make her have a total of 4 provs. Request id 4 will be
assign to Edison, since he has only 3 providers. and so on and so forth.....

Hope you can help me design a macro code here..... very important.