Hello Dear
Here I'm with a complicated situation, I have many styles packed goods in carton, now I have to re-pack again for air shipment, with below condition.
FILE IN GOOGLE DRIVE
Sheets are;
01.AIR-QTY
02.CURRENT-PACKING
03.DESIRED-PACKING
We will turn sheet "CURRENT-PACKING" to sheet "DESIRED-PACKING" (I have shown desired output for order no 599 & color B94, same will follow for others color accordingly).
Conditions are;
***We will match the Style no#, Order no & Col between sheet AIR-QTY & CURRENT-PACKING.
***In some cartons there are mixed sizes of goods, we won't repack those cartons.
***We will reduce/remove only complete carton from current-packing & won't break any carton.
***Quantity can't be less than the required AIR-QTY, we can keep more qty as we have to keep complete carton & we are not allowed to broke any complete carton.
***If the same size has in multiple rows (example in "desired-packing" order no-599, col-B94), then we have to calculate those (rows) qty to match with required aired qty in sheet AIR-QTY.
I want to have solutions in VB to do it faster.
How can I start?
Any help with the idea or with some code would be highly appreciated.
I have posted this in HERE , but getting the answer is taking a while, that's why asking here again.
air-qty
AIR-QTY.JPG
current-packing
CURRENT-PACKING.JPG
desired-packing
DESIRED-PACKING.JPG
Bookmarks