Ask: Do you use excel or VBA to make detailed warehouse records? (Monthly report can be automatically generated based on the receipt/issue details and inventory summary.)

It is suggested to establish an inventory file, including details such as category, product name, specifications, etc. (it is best to use codes, which are unique and easy to operate). Can you meet your needs by combining index+match and sumif? .

only the daily receipt/shipment details are entered in a table, and then summarized into the receipt/shipment/storage summary table through the sumif function (both the details and the summary table are consistent with the inventory file details established above).

What matters is the logic of thinking; There are templates. You can leave oil fragrance if necessary. It's your turn.

1. Details table header style:

2. Receipt/shipment/storage summary table style:

2022165438+1When will Shunde Internet Cafe resume business on October 23rd?

I am now in Langzhong, and I urgently need a small facade to do business. Is there a suitable place in Langzhong?

Details of Guanshan Mountain in ma chang xiang

What are the five elements of life in the sea missing? What is life in the sea?

What are the must-see tourist attractions in Beijing?

Tangshan City, Kaiping District Community Health Service Center open recruitment of paramedical staff announcement

Ranking of baking west point training schools

Is the food at the wedding banquet in Kunming delicious?

Which is good for Maojiabu farmhouse?

What does Meal Replacement Meal Ready Meal mean?