Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADefinitely a fun exercise!
Macro includes an output sheet to double check the logic of the iterative macro. Took a few tweaks to account for running out of inventory, but was able to accomplish via nested if then statements.