1. Make a daily warehousing table by month, fill in the daily warehousing quantity of the corresponding date, enter the formula =SUM(B3:AF3) in the last warehousing quantity cell, and drop down the formula to get the warehousing quantity of each product in the current month.

2. Make a monthly daily delivery table, fill in the daily delivery quantity on the corresponding date, enter the formula =SUM(B3:AF3) in the last delivery quantity cell, and drop down the formula to get the delivery quantity of each product in the current month.

3. Set up the month's warehousing summary table. First, fill in the balance quantity of last month at the beginning of the month, and then enter the formula =VLOOKUP(B3, receipt! A:AG, 33, 0), matching the warehousing quantity of the current month.

4. Enter the formula =VLOOKUP(B3, question! A:AG, 33,0), which matches the issue quantity of the current month.

5. Enter the formula =C3+D3-E3 in the final inventory quantity, that is, use last month's balance+receipt quantity-issue quantity to get the inventory quantity of the current month.