Hello. I am currently trying to create a very basic list of bulk inventory that can be easily updated.

The cell headers I have are as follows; location, item number, added or subtracted inventory, and actual inventory balance. The issue I have is that I would like to place a positive or negative integer in the added or subtracted inventory cell that would update the actual inventory balance. The other issue is that I would like the added or subtracted cell to be blank again after a number would be inputted.

Any help would be greatly appreciated.