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.