Challenge #14: Warehouse Distribution

[STate]

First intermediate challenge and it wasn't as intimidating as I thought it would be!

[Gauthier_B]

Done with joins and running total

[mickael_gest]

My solution :)

Spoiler

[CaraI]

Definitely a fun exercise!

Spoiler

Spoiler 

  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. 

[kcoulon]

Challenge Completed - non-macro version

[justynam]

My solution - with iterative macro :-)

[Jim7]

Attached is my solution, based on two multi-row formulas.

[justin_winter]

Pretty easy without iterative macro using running totals, sort orders, and multi-row formula!