Adding/Deducting from one table based on another

[j24]

First I would like to apologise if I have posted in the wrong forum or if this has been asked before.

I have created two tables Table 1 with these column headings:

Order No: Delivered To: Invoice To: Date: Code: Quantity Dispatched: Quantity Received

Table 2 with:

Code: Stock Level:

What I would like is to know if it is possible to depending on the code in Table 1 to deduct or add to the stock level in Table 2? And if it is how to do it. It has been so long since I have used excel for anything but the very basic things.

Basically I look after some of the stock at work and am looking to make a sheet that will tell me what is in stock and allow me to add when we receive and deduct when we dispatch. I have about 20 different product codes to work with. I realise that obviously a database would be an easier option but I only have Excel to work with.

I currently have a set up where I have several sheets all linked and have to basically clear the quantities and start again every week.

Any help would be greatly appreciated or letting me know it can't be done.

Many Thanks

[tridom]

Something like this?

Stock Qty.xlsx

[j24]

Hi Tridom,

Thanks thats great.

[tridom]

Hi Tridom,

Thanks thats great.

You are quite welcome!