warehouse management

  1. D

    Data consolidation with permanent cell and IF statement

    Hello, im having trouble with coming up with a formula for the following case: We have sheet with data about different products: Product Quantity Location Product 1 5 1-1-1 Product 1 10 1-1-1 Product 1 5 1-1-2 Product 2 10 1-1-2 Product 3 5 1-1-2 Product 3 10 1-1-3 Our...
    • dmelnik
    • Thread
    • combine consolidation excel if statement warehouse management
    • Replies: 3
    • Forum: Excel Questions
  2. C

    Extracting multiple strings of data from one cell

    Hi Everybody. I'm in a bit of a pickle and i'm hoping someone can help me. The current situation: Our stock dispatcher in the past has been using a spreadsheet that only he understands and even then, the convoluted ways he goes about tracking stock quantities and locations means he doesn't...
    • Cpt_Carbs
    • Thread
    • help excel formula please location stock control strings within cell warehouse management
    • Replies: 8
    • Forum: Excel Questions
  3. D

    Excel wkbks.wkshts into access

    There is my computer that I will pull reports to.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> There are 5 locations entering current inventory (each with a wkbk)<o:p></o:p> I than have a separate sheet for the backstock req'd for each inventory...
    • doug5jmp
    • Thread
    • access 2007 excel 03 and access 03 inventory warehouse management
    • Replies: 5
    • Forum: Microsoft Access

Some videos you may like

This Week's Hot Topics

Top