vlookup, if then else, etc

jnblack9

New Member
Joined
Apr 19, 2019
Messages
1
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?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,223,903
Messages
6,175,287
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top