I have to create an inventory checklit based on an Excel document
I will have 2 main sheets: Inventory & Picks
Inventory will have a list of all the SKU/units that we have per product.
Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough units for this product.
The idea is that once I have a project, I can select items from a list that will be taking values from the inventory sheet and will tell me how many items do I have available.
The question is: How can I make the "Picks" sheet take the content from the "inventory" sheet and tell me how many units do we have or if we have to reorder.
Attached is an example of what I need.
