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
My solution:
Spoiler
No macro, just simple maths.
Combine store & orders, to be able to sort on priority and item, then add a runningsum per item. Then combine this with the warehouse - stock data, add a formula to check stock against that runningsum, when stock is higher, fill entire order. When stock is lower, check if the line can be partially filled, otherwise 0. Then just a sort and select to present the data as requested.
Combine store & orders, to be able to sort on priority and item, then add a runningsum per item. Then combine this with the warehouse - stock data, add a formula to check stock against that runningsum, when stock is higher, fill entire order. When stock is lower, check if the line can be partially filled, otherwise 0. Then just a sort and select to present the data as requested.
Slightly different output - I included a "Remaining" column and left it sorted by Item and Priority.
