See if you can adapt this macro, to be pasted in the sheet's module since it uses event WorkSheet_Change to trigger, to your project. If not, use it as trace.
I'm assuming that your stock items start from row 6 (headers in row 5) of column A and the quantity for each item is in column H.
As "Front End" what you also need is two place-holders, one for items to be added and one for items to be subtracted; I have choosen A1 and A2.
Now all you need to do is position the cursor in the cell for the choosen operation and use your Wasp. If the item is found in the list in column A the macro will preform the operation and add o subtract in column H elsewise you will have feedback.
Bookmarks