Hello all expert
i create this excel sheet that have two button for make the following action
1- Click here to add Stock Quantity
which will open form that allow enter data from manufacture to stockdatabase sheet
2-Click here to add Withdraw Quantity that allow enter data withdrawed or sold to withdrawdatabase sheet
the problem now i need when i open withdraw form nd enter value excess from corresponding data in stock , give me message that
the number enter in quantity is more than stock
for example in my example
in sheet Withdrawdatabase in row 10
have product Settling TSA batch 1111
and this batch quantity produced in stock was 450 from Stockdatabase in row 2
and in withdraw its sold for two locate before (row 2,3 ) (150, 300) and again in row 10 location 1 have 200
i need to prevent this to accept number more than stock
best regards
Bookmarks