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