warehouse management

Hello all! First time I post in a forum for a excel issue I would like to solve. Hope you can help me, thank you for your time in advance. The problem I have is based on stock of product that I need to send to different locations -Warehouses-. Let's say I have 5 warehouses, each of them with a...

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

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

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