Update total "In Stock" on separate workbook automatically

[nicolemm83]

Hi,
I am hoping someone can help me with this - I have two workbooks, one is the inventory master, with product name, id, qty, cost, markup, etc. (attached) and the second is the order workbook, which has drop down menu for products, qty, and cost and sell price totals (attached) - and all info is transferred between workbooks using VLOOKUP.

I would like to be able to have the in stock qty in the inventory master workbook automatically deduct the qty that is being ordered from the order workbook.

I hope that this makes some sense - I am sorry if I am not being clear. But please, any advice is helpful.

Cheers,
Nic.