Stock register, calculation mechanic.

Hello!

I'm new to Excel but have an important task that needs to done, and it needs to be functional.
I have been given the assignment of making a Stock Register, that is easy enough, bu the crucial detail is
that the register needs to be able to automatically update its numbers:

Say you add 15 items of a given sort, and submit this to the column "Incoming quantity",
then the column for "Quantity in stock" should update itself accordingly.

That is the mechanic I want to be able to add.
I hope this makes sense....

Thankfull for any help.

Hi

Hopefully this works as you intended it to work. Let me know if you wanted something else (if you wanted something else, please attach an example, that I can get an idea of what you need).

Have a good one.

Cheers

I see that you have Excel 2003.

Don't think you'll be able to view the attachment.

Here's the 97-2003 Version.