Hi all,
I have a workbook with 2 worksheets - Sales and Inventory (attached an example). The sales sheet documents all sales made by my company, with cost and quantity of the items sold, and the inventory includes how many of each we have in stock. I want this inventory to automatically update with the sales.
Example:
In the example workbook attached, we are selling tennis balls, footballs and rugby balls (ignore the cost) - we have 2 separate sales, each with different quantities for the different balls. On the inventory page, BEFORE taking those sales in to account, we have 10 in stock of each item.
I want the inventory to automatically update to show that we only have 7 in stock on the inventory page for each item (given we sold 3 of each from 2 sales) - any help please? We do have 3 digit product codes for our products if it helps to add a column in with numbers instead.
Best,
John
Bookmarks