How to reduce the number of WPS tables according to the preset number

I don't understand the relationship between your two forms.

Here's an introduction according to my train of thought and an answer:

1. If there is a daily report, see the figure below. If there are two forms, it doesn't matter. Please refer to the same:

What we want to achieve is to fill in the quantity sold in column D and automatically display the remaining quantity of "actual inventory" in column E.

2. click E2->; Enter "="-> in the edit bar and click C2->; Enter "-"-> click D2, and the edit bar will display "=C2-D2":

Finally, don't forget to click "√", and this line will be done.

You don't need to input serial numbers 2 and 3 one by one, just "copy" E2 and paste it into E3 and E4 in turn.

4. If three "video wardrobes" are sold this month (enter 3 in D2), then E2 will automatically calculate 20-3= 17.

If Physical Inventory is in another table or another table, the method is the same.