EXCEL garment accessories warehouse in-out management table
It is suggested to establish an inventory file to list all the material details of the company (such as specifications, models, measurement units, etc.). ) and attach the code. For daily material tracking, please attach product code. The warehouse sends and receives inventory forms. With the newly established inventory file, combined with index+match and sumif, your needs can basically be met. If necessary, you can leave the fuel tank and transfer it to a template for sending and receiving inventory forms.