1. Date: the specific date of picking up materials;
2. Receiving department: The name of the department that receives materials is detailed to the team. Filling in this item is related to the correct collection of department consumption;
3. Department head: head of the material receiving department;
4. Warehouse management: Fill in this column to identify the specific personnel who distribute materials. For subsequent problems that may arise, the parties can be found in a timely manner to solve them;
5. Applicant: The actual person who collects the materials. Fill in this column to identify the person who collects the materials. For any subsequent problems that may arise, the parties can be found in a timely manner to solve them;
6. Name: The name of the required materials. Filling in this column is related to the accuracy of entry by warehouse personnel when doing accounting;
7. Model/Specification: The specifications of the materials to be used. Filling in this column is related to the accuracy of the entry by the warehouse personnel when doing accounting;
8. Purpose/Precautions: The purpose of the materials to be used;
9. Quantity: The quantity and unit of the materials required. Filling in this column is related to the balance of the inventory account;
10. Remarks: Other instructions that need to be added.
1: Hide the chapter list
Select the first line, hold down [shift+F] to open the "Find and Replace" dialog box, "Remarks to find all, hold down shift+A to select all, then close the dialog box, hold down [ctri+0] to hide
2: Quickly select specific columns
Select the table area, click the "Create from selected content" dialog box under the [Formula] tab, and select "First Row". After the settings are completed, open the name box in the upper left corner, and click the corresponding list to jump to the specified column.
Two column name verification
If you want to check whether the name in Table 2 appears in Table 1, a formula can be used to do it immediately.
=IF(COUNTIF(A:A,C2),"Yes","No")
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)
Warehouse picking registration formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Property management household electricity bill statistics table,Property management household water bill statistics tableDownload to get the source file, which you can edit, modify and replace. Download the warehouse picking registration form and go to Huajun Software Park.
it works
it works
it works