Hello all,

I need your help

I have one file to stock management and i cant subtract the stock value

In the tab demand i have my client demand with the part number, the qty demand and the Stock OK?.

i want to search in the tab stock if the stock is enouf then put "OK" else put "NOK". when do the search it subtract the stock value.



example:

Tab demand range C2 = OK; Tab stock range B2=0
Tab demand range C3 = OK; Tab stock range B3=1
Tab demand range C4 = NOK; Tab stock range B4=-2


Can someone help me?

stock.JPG
Demand.JPG