Forum Discussion
Difficult Formula Help Please
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.
Can I get a free case of T-shirt when I'm done with this? lol!
Look at the attached. I fixed the issues you were having on the first 3 tabs.
For the last two tabs, I need to put a bit more thinking. If I got it right, you want a summary for Gildan only and another one for US apparel only. Correct?
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.
