Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThat took some time and thinking!
This probably lended itself to an iterative macro, but I did it the brute force way instead since still getting the hang of macros. I sorted by item and priority,grouped by item, and then started subtracting from inventory for each item. To calculate assigned- if inventory was still positive or 0, then it was equal to required. Elseif abs(inventory) > required, then 0, otherwise required+inventory to get the amount fulfilled.
Back at it to try and get my advanced cert! This took me forever to figure out... Managed it with the iterative macro in the end!!
Tried it without Macro