Now Baidu knows that many people in the world have asked such questions, and I have answered a lot.

First of all, we must clarify the following points:

1, which is difficult to realize simply with formula function;

2. Even if it is barely realized (using many functions such as if sumif vlookup and plus pivot table), the speed will be very slow.

3, don't be superstitious about ready-made content, someone will send it to you, but not necessarily someone willing to spend a few days to modify it for you.

4. The solution is still through VBA. Many people have this doubt, such as worrying about macro viruses and worrying that the code can't be understood. In fact, if you are worried about viruses and don't use VBA tools, you'd better not use a computer.

What I introduced to you is the VBA warehouse management tool developed by our company. Not only VBA code is used, but also the database technology of Excel is used. You can download it. No matter whether you download the free version or the trial version, I can guarantee that there is no virus, but I don't promise to open the code to you. Baidu searches the website of Beijing Futongwei Technology Co., Ltd., and there is an address on the company website. If you can't find it, you can go to my Baidu space to find a post. If you have no patience, you can directly Baidu hi me. If you don't know, then you can continue to be depressed. The following is an introduction:

The small warehouse/warehouse/invoicing management tool adopts Excel database engine technology and is designed and developed according to the idea of software engineering, which is stable, simple and practical. No additional files are required, and no installation and setup is required on any system. It has complete warehouse and inventory management functions, such as warehouse management function, inventory management function and cargo space management function. According to the production date, FIFO can be realized, inventory cost and sales profit can be calculated, daily, weekly and monthly reports can be counted, and the warehousing history can be queried. Widely used in warehouse management of small and medium-sized logistics enterprises, inventory management of various production enterprises and inventory management of various commercial enterprises.