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...
  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...
  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...

Some videos you may like

This Week's Hot Topics