The first worksheet is the main inventory table, with number, name, specification, unit, quantity, unit price, amount, warehouse,

On the right side of each inventory in the main table, add receipt/issue quantity, unit price, description, receiver, date and receipt/issue number.

Then write a button (title: bookkeeping) with VBA, whose function is to write the records in the main table whose in-and-out quantity is not equal to 0 into the second table: detailed records. Update the quantity, unit price and amount of the main table at the same time.

Every time (negative number) is put into storage (positive number), fill in the entry-exit crying column and fill in relevant information.

After filling it out, click the charge to an account button to record the details of each item, and at the same time, the main table will be updated accordingly.