Automatic update of values of a spread sheet from another whenthere is change,new entry

Welcome to the forum ESTHER

What about STOCK IN?

Please attach a workbook containing your 3 sheets

To attach a file, click on "Go Advanced" and then below on "Manage Attachments" etc

Hello Kev,
I really appreciate you efforts to assist me. Okay i am uploading the file right away, Thank you so much.

Hi dear, how are you today, i take this opportunity to express my gratitude to you for your support. Honestly you have been very helpful, thank you so much. The formula is working well however, whenever i input orders of the same invoice ID in different days, it wont automatically update. For instance invoice AMC-001 was ordered there times i.e on 4/1/017 and twice on 7/01/017, the quantity in stock balance sheet however does not pick the other two orders, it has only picked the first order in entered which is on 4/01/017. Is there a formula or rather a function i can use to make the quantity in the STOCK BALANCE sheet update itself no matter how many times the orders have been made from the ORDERS sheet.
Kindly assist me if you are in a position to.
Regards,

please attach your workbook with those values included so that I can see what has gone wrong

Hello, find it as attached dear.

I entered three orders with invoice "AMC-001" with order quantities of 20, 10 and 5 (total 35) and Quantity on the "Stock Balance" sheet shows 145 (180 - 35) with "OrderS2 column value of 35.

The SUMIF will SUM all orders with same Invoice Number.

An issue you have is that the "Available Stock" in sheet "Stock2017" should now show 145 not 180.

Hello,
Find the workbook below.
Thank you so much.

Hello
I really appreciate your support.Have you attached the workbook, or where have you entered the values dear, i cant see any attached workbook.

Total order quantity for AMC-001 is 220 which is the ORDER value in "Stock Balance" so it is working.

Hi dear,
Order means stock out, as in what we have sold to our clients.
Thanks

Hi,
According to my need in the worksheet; stock 2017(available stock)-orders(what has been sold)= stock balance(stock in hand)

I am trying but still it wont work dear.

Hi,
I decided to remove purchase stock as initially it was confusing me more, so what i did, i simply decided that i will be adding any purchase stock(stock in) in the sheet;stock 2017. So with that in mind all i need are three sheets; the stock 2017 which is the combination of stock in and initial stock available., the second sheet will be the orders(stock out or what is being sold to our clients) and finally the third sheet with stock balance(what is remaining) whereby the third sheet can have both the details of the two sheets all together and of course provide me with the balance.
THANKS.

Hi John, Note that the sheet stock 2017 is the opening stock, so it doesn't have to change, what i need to change is the balance in sheet 3.
Thanks

Stock Balance needs to change as per AVK example.