Challenge #14: Warehouse Distribution

[Niklas]

Solved.

[ConradW]

Challenge 14 complete

[rslopez2]

Pulled a little inspiration from @JoeM 's great Batch Macro tutorial referenced in the Advanced Cert Prep Guide and went batch macro route!

Batch Macro

1)Sorts by Store Priority to ensure you are filling all product orders for prioritized stores first

2)Uses the control parameter to Group/Batch by Item and map it to insert the beginning Count available for each item

-Use multi Row formulas to calculate correct item assignment 

Spoiler

Spoiler

[Vidya26]

My Solution!!

[Tom_Luthi]

solution attached.

[ewang]

Here is my solution with a interactive macro

[chetty]

My solution attached

[TimothyManning]

Spoiler

[wdavis]

Achieved without using a macro. After joining all the data together, I used a couple of Multi-row Formula's to build out the logic of how much stock they should be assigned!

[kennetheng]

Took a semi complicated IF statement but eventually got the solution!