We have small Stationery Shop. so we decide for Update that inventory using excel spread sheet.
that spread sheet Have a Full Stock Quantity & Sale Quantity Column. I want to update it day by day.
That means first day customers get a 3 quantity in 100 full stock balance must be 97.
second day customers get a 5 quantity, Balance must be 97 - 5 = 92.
How I create this formula in Excel spread sheet.
Please Help me.