Results 1 to 3 of 3

Thread: Inventory Allocation based on Warehouses near expiry and less Qty location

  1. #1
    Seeker majid's Avatar
    Join Date
    Oct 2018
    Location
    pakistan
    Posts
    6
    Articles
    0
    Excel Version
    2013

    Inventory Allocation based on Warehouses near expiry and less Qty location



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,
    i need your help to identify Pick items based on near expiry and less qty location warehouses. i do on a sheet manually to present what i want. its a scenario based problem. kindly tell me if it is possible pivot table. please review the attached sheet.
    i want first Qty, Location and Lot based on above criteria.
    Thanks
    Attached Files Attached Files

  2. #2
    Seeker majid's Avatar
    Join Date
    Oct 2018
    Location
    pakistan
    Posts
    6
    Articles
    0
    Excel Version
    2013
    Hi all,
    you can change this Data by warehouse, like where W-1 Data end to paste W-2 Data and so on. actually this data are in four sheets W-1, W-2, W-3 and W-4.

  3. #3
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,686
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Again no link added to cross post. Already warned multiple times. Banned 7 days.Thread closed
    Last edited by Pecoflyer; 2019-02-25 at 05:17 PM.
    Thank you Ken for this secure forum.

Posting Permissions

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