Hopefully I can explain this logically, bear with me
Currently, I have a sales sheet where I enter the details of our sales.
DATE | PRODUCT SOLD | QTY SOLD | CUSTOMER DETAILS
The “Product Sold” field is simply copied and pasted from the previous line and I have this field as a dropdown which contains all our products.
What I would love to have is this …
DATE | PRODUCT SOLD | QTY AVAILABLE | QTY SOLD | CUSTOMER DETAILS
I understand I’d likely need to have another sheet with all the products listed there along with the qty’s available, etc but I can’t get my head around how I would get what I wanted without a massive formula that would have to be applied to each cell on the “sales” sheet which could be quite unworkable.
Essentially I’m looking for a way to have another sheet, like a stock sheet, with the products and qty’s available and have those qty’s shown on the sales sheet once I selected the product from the dropdown we have there currently. Obviously this would also need to be adjusted automatically too, so when I select PRODUCT1 on the sales sheet and enter QTY SOLD 3, if the QTY AVAILABLE was previously 4 from the stock sheet this now show QTY AVAILABLE 1 on both the sales sheet and the stock sheet.
Hope that all makes sense
All the best