Hey guys, I am really stuck so any help would be hugely appreciated.
I am creating an inventory model for work and have created a dashboard where you can choose a part number and the availability of that part shows up and then you can enter the number of items ordered. Once the user hits enter, the order goes into a purchase log with the time and date of the order.
Here is where I am having trouble... I want to subtract the purchase log orders from the stock levels for each part number which are displayed in various sheets. I can do that when a part has only entered the log once, but when there is more than one transaction for the same part number I canít seem to solve the issue. I tried an index and match function but that simply returns the first transaction for each part number.
Please refer the the attached example where I would like to adjust the stock level in the part number sheets.
Again, any help would be hugely appreciated!