https://drive.google.com/file/d/1ly_TVkX804dgmNfMscyBRXCAs3vtx-jp/view?usp=sharing
I have built a sheet that helps me manage my inventory. I have a BIN REPORT and REC INPUT tab where i update information which then feeds to my CONSOLIDATION tab which helps me minimize warehouse space. I even have a STOCK LABEL tab that generates skid labels automatically for me. (although that doesn't work properly yet because it depends on this next problem to be fixed first) The only thing i can not figure out how to do is my PUT AWAY tab. This tabs main purpose is to take the receiver amount coming into my warehouse and divide it by set skid quantities, making a new line for each full skid amount and any remainder, (ie 420 pcs of a part coming in, with skid quantities of 80 would generate 6 lines of that part number, 5 with qtys of 80 and the 6th with a qty of 20) which would then prompt my STOCK LABEL tab to properly generate a label for each skid. I have googled every which way i can think of to try to solve this on my own. Please can someone help me figure out how to build a formula on my PUT AWAY tab that will generate as many lines as needed for the first part # then, once that part #'s qty is depleted, will move on to the next part # on the list from the REC INPUT tab and continue to move down the list of parts on REC INPUT tab?
I have built a sheet that helps me manage my inventory. I have a BIN REPORT and REC INPUT tab where i update information which then feeds to my CONSOLIDATION tab which helps me minimize warehouse space. I even have a STOCK LABEL tab that generates skid labels automatically for me. (although that doesn't work properly yet because it depends on this next problem to be fixed first) The only thing i can not figure out how to do is my PUT AWAY tab. This tabs main purpose is to take the receiver amount coming into my warehouse and divide it by set skid quantities, making a new line for each full skid amount and any remainder, (ie 420 pcs of a part coming in, with skid quantities of 80 would generate 6 lines of that part number, 5 with qtys of 80 and the 6th with a qty of 20) which would then prompt my STOCK LABEL tab to properly generate a label for each skid. I have googled every which way i can think of to try to solve this on my own. Please can someone help me figure out how to build a formula on my PUT AWAY tab that will generate as many lines as needed for the first part # then, once that part #'s qty is depleted, will move on to the next part # on the list from the REC INPUT tab and continue to move down the list of parts on REC INPUT tab?