I am using excel to manage inventory. I maintain a spreadsheet which has activity of each stock item. sometimes I create a mixture of 2 different stock items to sell. I enter the details of the mixture on another sub sheet. Is there a way in which the quantity that I use from each stock item gets deducted from the activity of that stock item simultaneously, without my having to go to the activity and doing it manually.
Bookmarks