Want to get involved? We're always looking for ideas and content for Weekly Challenges.
" Running Total "
My solution attached.
Used a combination of sorting and multi row formula to allocate the inventory from the warehouse to the stores in the appropriate manner.
Hi! Here is my take :-)
My thirty-fourth workflow! Done!
Really didn't need to do a Macro, especially since I then had to debug it and figure out why things weren't joining properly, but hey, it gave the needed result.