My problem is this:

I have a list of items i column A. In the next column there is the quantity of each item.
The probl;em is to updat the quantities. FRor eample:

A B C
1 item quantity update
2 brickA 10 5

I know that it is very simple to add the 5 new items to the total (10)
Then the new quantity is 15
After that calculation, I want to clean the quantity in column C to make it ready for a new input
But when I clean cel C2, the total changes back to 10... I want the 15 remains there, but how?


Can I do this by norma formulas or is VBA the only solution
I'm completely new to VBA

Thanks in advanve

Coen