Hello i need some help with the inserted formulas, a couple features aren't working that were and i cant figure it out i have a master sheet in a workbook another sheet is sales and another is to add inventory. I had it that the master sheet would automatically update the stock level when an entry from sales or adding inventory was entered, and would update the stock accordingly. This is not working on one of the sheets and I'mhaving a hard time seeing where the issue is.
Also when an inventory item is sold or added that the price is auto populated from the master sheet, this is no longer working.
I would like enter a discount formula for bulk buying at a lower price and that the inventory would also be adjusted accordingly.
Thank you for any help offered
Bookmarks