1. First, create a new worksheet named "1 month" and set the header information as shown below.

2. Secondly, create a new table named "Data Table" to store material numbers and names.

3. Next, define the item number and name as the name, so as to input data in the inventory summary table. Step: select A 1:B 1 1 area of data table, and click Formula Definition Name-Create Based on Selection.

4. In the pop-up interface, select the first line and click OK.

5. Return to the table of "65438+ 10 month", select the blank area of column B, and click Data-Data Validity-and select the Data Validity button in the drop-down menu.