Hi all,
See attached workbook which is a stock order workbook with a summary re-order sheet - (thanks to NBVC for the help on this)!!!
The problem I have is that as the running balance effects the re-order column the summary re-order sheet will re-order from a the date that stock is needed onwards until someone types in stock recieved to get the balance right.
I need another condition within the summary sheet sumproduct formula so that the order will only go through once and not be repeated until a new figure is added into the number issued column on a future date.
All help appriciated!!!
Bookmarks