Hi All,

I am very much a novice on excel so please bear with me!
I am trying to create a very basic spreadsheet that I can use to keep track of stock items. What I want to do is to be able to update a particular stocks total when either stock is added or stock is taken. I am not very familiar with formulas, but what I want is when I add or remove stock the total updates accordingly, then if I need to update the same stock again, I can do so with the newly updated total now being the source that is updated - I hope that this makes sense?

Hope someone can help.

Best regards