ok - columns A + B tell me what I need to order.
J + K will update A + B
difference between A/B is just /6 as 6 drinks per pack.
To put in values into J OR K which will update A + B .
not sure how to do this. ask if more info required or adaminnit sky pe
if you put 1 in K it should DECREASE A by 6 and B by 1.
if you put 1 in J it should DECREASE A by 1 and B by 1/6
spot on - thank you.