Hi,
I have been trying to allocate inventory based on a set of conditions one of them being the due date the other is the order completion. I have not been able to automate this process though! Please do let me know if you are aware of a way in which this can be done.
Thanks..
you can try this formula in cell E2 and copy it down the column:
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Merci boku for replying Pierre..
I changed the orders a bit and then unfortunately hit another roadblock :'(
It seems to be adding up order quantity w/o considering item numbers
Here's the attachment
allocated inventory v0.2.xlsx
I know I'm going to sound like a pain... but it would really be of great help to me if you could possibly explain it a bit .... Thanks a lot in advance
Last edited by vgr; 04-05-2014 at 06:17 AM.
Ok, I think I see the problem. In the SUMIF functions, the search value (second parameter) was $C$2 and it should really be $C2 which means it always look at column C but the row will change when you copy the formula down the column.
Here is the modified formula.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks