Hello.
I have 2 Sheets. In one I have set 3 product categories, each one has any Specifically products.
At the same sheet, there are all products with available quantities.
On the other Sheet, that is for orders, in column C, the user selects from a list of product category. In the next column(D), I like to display a list of products only in this category and only if quantities are available for this product.
So this means that any quantity of any product, bound to order, should be removed from stock this product
I attach you, a test file, to better understand my point.
Thank you in advance
Bookmarks