Assigning X amount of assignments per day

[Craigc3814]

Once a month I download a list of workorders for my company and assign X amount of work orders to each group per day (table below). Another table is the list of each and every work order we have. I want to assign work orders based on the amount per day specified in the table below. So on September 1st I would want 1 Elec GASMON work order assigned to ELEC then the next work order to be assigned on 9/2 then 9/3 and so on until all work orders have been assigned. Then I want it to look at Elec RGUAGE and assign the first six to ELEC on 9/1 then the next 6 assigned to ELEC on 9/2 and so on. Is this possible?

[TABLE="width: 374"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Responsibility[/TD]
[TD]Activity[/TD]
[TD]Assign To[/TD]
[TD]Assign Per Day[/TD]
[/TR]
[TR]
[TD]ELEC[/TD]
[TD]GASMON[/TD]
[TD]ELEC[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ELEC[/TD]
[TD]RGAUGE[/TD]
[TD]RGAUGE[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]ELEC[/TD]
[TD]GEN3[/TD]
[TD]ELEC[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]ELEC[/TD]
[TD]GEN1[/TD]
[TD]ELEC[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ELEC[/TD]
[TD]ELECPS[/TD]
[TD]ELEC[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]ELEC[/TD]
[TD]TPHV1MO[/TD]
[TD]ELEC[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]GENERAL B1[/TD]
[TD]PSMNTH[/TD]
[TD]B1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]GENERAL B2[/TD]
[TD]PSMNTH[/TD]
[TD]B2[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]GENERAL B3[/TD]
[TD]PSMNTH[/TD]
[TD]B3[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]GENERAL B4[/TD]
[TD]PSMNTH[/TD]
[TD]B4[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]GENERAL C1[/TD]
[TD]PSMNTH[/TD]
[TD]C1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]GENERAL C1[/TD]
[TD]OCSBIO[/TD]
[TD]C1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]GENERAL C2[/TD]
[TD]PSMNTH[/TD]
[TD]C2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]GENERAL C2[/TD]
[TD]MOS[/TD]
[TD]C2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]GENERAL C2[/TD]
[TD]SWPS1D[/TD]
[TD]C2[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]MECH[/TD]
[TD]SHOPEQ[/TD]
[TD]Mech[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]MECH[/TD]
[TD]SUMP[/TD]
[TD]Mech[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]MECH[/TD]
[TD]AIRS1M[/TD]
[TD]Mech[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]MECH[/TD]
[TD]PMPDD2[/TD]
[TD]Mech[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]MECH[/TD]
[TD]SUBPMP[/TD]
[TD]Mech[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]MECH[/TD]
[TD]GRINMA[/TD]
[TD]Mech[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]MECH[/TD]
[TD]PSDRAW[/TD]
[TD]Mech[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]PLAN[/TD]
[TD]GEN2[/TD]
[TD]Mech[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[Craigc3814]

Thread if no longer needed, please delete