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

Challenge #14: Warehouse Distribution

cgoodman3
14 - Magnetar
14 - Magnetar

Without a macro for this one:

Spoiler
Challenge 14.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
DiegoParker
10 - Fireball

I must say I didn't know how to do this with a macro so I just used a few multi-rows.

RobertoEstrada
8 - Asteroid

Here is my solution. Probably not the best so I need to continue practicing a lot the use of the different tools available.

Cory_Snook
6 - Meteoroid

Messy but effective.

Spoiler
challenge14.png
NoraW
7 - Meteor

Tried out the iterative macro approach...

 

Spoiler
Macro.PNGMain workflow.PNG

 

echuong
8 - Asteroid

A little bit of a different approach than the posted solution...the instructions didn't say to allocate products to stores that didn't have a requirement, so my answer differs a little

jagdeep_singh85
8 - Asteroid

PFA my solution

Lily_Unsworth
8 - Asteroid
 
joemkcarr
8 - Asteroid

Done with a batch and an iterative macro to practise

Asal
7 - Meteor

This is mine,still thinking if I can replace  a formula instead of Running Tool+ Multi-Field Formula!