I need to make a simple spreadsheet to track inventory. Column A is Received, B is Shipped, C is On hand. When a number is entered into A, quantity is added to C. When number is entered into B, quantity is subtracted from C. I need the cells in A and B to be reset to 0 after calculations are made. Simple formulas wont work because the cells will not reset to 0. I need VBA code but I don't no how to write it.

Thanks,
Chris