Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto assign project
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to auto-assign number | Excel Discussion (Misc queries) | |||
Assign a project name to weekly hours/pay | Excel Programming | |||
how to auto assign po numbers in Excel | Excel Worksheet Functions | |||
how to auto assign po numbers in Excel | Excel Worksheet Functions | |||
assign auto number and auto date | Excel Discussion (Misc queries) |