return a value to another sheet and decrease the amount of stock on that product

[kdolba]

Hi, I have 2 sheets one is product list and the other is for sales. I want to make it so when I enter the barcode of a product, it returns the name and price of that product to the sales list, and I want the stock amount to decrease depending on the amount we have sold. I have already figured out the returning value of barcode by using vlookup but I don't know how to decrease the amount of stock.

[Kaper]

Welcome to the forum,

Adjust adresses in provided below formula according to your workbook.
I assumed below that Product list is in products worksheet starting (header) in cell A1
and Sales List is in Sales worksheet also starting in A1

change cell D1 in Products to "initial quantity" and write in E1 "remaining quantity".
Then in E2 write:

=D2-sumif(Sales!A:A,A2,Sales!D:D)

and copy down.

To make (next time you write on forum) helping easier: follow the suggestion from yellow banner at the top of the page and attach sample workbook

[kdolba]

Thank you so much