+ Reply to Thread
Results 1 to 2 of 2

Complicated situation - have to repack goods in VBA

  1. #1
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Post Complicated situation - have to repack goods in VBA

    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

  2. #2
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Complicated situation - have to repack goods in VBA

    bump-------

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. take the value of the goods + add up to the price
    By DianChris in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-18-2020, 10:47 PM
  2. using Vlookup to get value of goods sold
    By cybershot in forum Excel General
    Replies: 3
    Last Post: 04-11-2019, 12:20 AM
  3. Goods in, Goods out spreadsheet help
    By andyroe208 in forum Excel General
    Replies: 5
    Last Post: 09-08-2015, 12:35 AM
  4. [SOLVED] Goods reservation system
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-11-2014, 04:03 PM
  5. VAT for second-hand goods
    By Patrick_kingshott in forum Excel General
    Replies: 6
    Last Post: 12-20-2011, 05:08 PM
  6. Complicated IF/MATCH situation
    By rrbest in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2010, 06:52 PM
  7. [SOLVED] Database for Purchased goods
    By Troy in forum Excel General
    Replies: 2
    Last Post: 07-14-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1