As attached below I have two tables as imaginary examples for number of boxes each contain a certain number of units which need to be distributed evenly or as requested according to the requested number of units.
Noting that:
1- every box is distributed as a whole (i.e No more than one worker can be assigned to the same box), so a worker can take more or less than requested based on the available boxes (e.g
Julien needs 140 units so based on the available boxes he can take box id H505 and Z101 or H505 and C800.
2- Box id is unique for each box.
3- every other factor is variable (no. of workers, no. of units, no. of boxes, etc.....)
is there any way possible to automate this task using excel or VBA or whatsoever?
Noting that:
1- every box is distributed as a whole (i.e No more than one worker can be assigned to the same box), so a worker can take more or less than requested based on the available boxes (e.g
Julien needs 140 units so based on the available boxes he can take box id H505 and Z101 or H505 and C800.
2- Box id is unique for each box.
3- every other factor is variable (no. of workers, no. of units, no. of boxes, etc.....)
is there any way possible to automate this task using excel or VBA or whatsoever?
Last edited: