Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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!!
Macro didn't really make sense to me either...
