hello, I am looking for help with regards to setting up an inventory list that calculates how much stock has been used from another worksheet or workbook [stock], then calculating how much stock is needed to reorder in worksheet [inventory]. I would appreciate and HELP, as I have looked through the forums to find this simple task and cannot find any relating answers. the inventory should show the total of re-order in the "yellow column" from the stock used in the next worksheet.
This is an unfinished workbook as my ultimate plan is to add more stock to the inventory and more names to the stock. I have attached the 2 worksheets for any answers to my query.
Bookmarks