Order book problem.xlsx
Hi,
heres another problem I am trying to solve.
I have 2 order books.
One is alist of all the orders that I have- customer ,product code,order no., qty,date required
Two - is alist of promotional orders that I seperate out into the week that it is required
Two is entered manually as I identify these by the non standard reqiremnt from that customer-I then add it to a further spreadhseet in the week reqd against the product code
What I am tring to do is caluclate the overall order qty-excluding the promotional requirments, eg my order book for product a- minus the promotional order book.
I could identify these by order no.s beginning PR if required.
So I want to compare the order book aginst the promotional order book and reduce the order book by the promotional qty-even if its not on the order book- however if it is on the order book and is on the promotional order book that is fine.As it zeros out.
However if I add a manual promotional order-eg the customer has told me they want it but havent done the offical order yet so it isnt on my order book-the qty on the order book is reduced by that entry on the promotional order book when it shouldn't be- bit still used as a future order ( eg a requirment without an order) which I can handle???
any thoughts- I think it may be index match but it wont work for me! or sum if the customer,product code,order no. and qty match one found on the order book?
Bookmarks