Forum Discussion
Difficult Formula Help Please
- Oct 16, 2020
Hi T-Meyers,
Take a look at this. I think there's more work to be done but it's a start.
In sheet "reorder insert" column K and L are essentially the same. Or I missed something in your explanations.
I took the liberty to add a conditional formatting in sheet "Break down" so you can quickly spot your numbers in the grid.
I added a few examples for testing, take a look and let me know if you need any fine tuning.
Take a look at this updated version.
In Sheet "US apparel Reorder Sheet" I made some modifications. All you need to do is input every possible codes (this will take time, I hope you have a list already) in column "A" (e.g. BLT0519-1-WCRL-S) and the remaining cells (style, description, color, grade and size) will fill out automatically. Then, if that code has an order quantity associated to it, it will add it at the end. I assumed you wanted to know how many cases needed to be order for each code but you can easily change that for the number of actual T-shirt will be ordered.
If that suits your needs, you can use that sheet as a template for any brand you add.