I am trying to manage my inventory in excel. My stock sheet has a column of unique skus of each product in column "A" and stock quantities in column "B".
I get excel files for my daily sales containing skus and its respective sold quantities. e.g If I have sold one sku twice its presented separately in the saily sales sheet.
I want to create a formula that can sum the total sale of each sku in that day and then subtract it from the stock sheet so I can keep my stock sheet updated.
Is it possible to do it in one go?
I hope I have explained it well enough.
Bookmarks