Automating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything

Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I m...