Dear vletm,
it took me some time to finally get to the computer and take a look at your version. OMG i'm baffled. This miles and miles further. I really like how you dealed all info in one sheet. That's amazing. I'll take some time so i can fully understand the code, and I'm sure I'll learn a...
How do You get or update each stocks information? And Which sheets would be those five stocks?
Its a manual process. First, in the "total" sheet I set which label and products we are going to count (we have 40k+ different products, so we count label by label, as an example in this saved file...
Hi there,
I have a logic problem. I want to reallocate our stock in 5 stores so we have a close balance between them. I want to make a spreadsheet that instructs automatically which products, from where, to where, and how many, so I can have it as evenly distribuited as possible.
I have done...