Fast input with a specific function

At work, whether for word processing or production of the report, may have to import large numbers of duplicate data.
Using Word's "AutoCorrect" command ("Tools" menu) can skillfully fast data input, but in Excel, but no similar menu command. But it comes with the VLOOKUP function can be clever solution to this problem. Such as processing sales data, a lot of the same unit often have to enter the name, you can use the VLOOKUP function, just type a letter so that we can quickly enter the name of achieving unit.
1. Create the source worksheet
Into Excel 7, click "File" menu, then click "New" command to create a new workbook.
Sheet1 worksheet to create sales reports, method is to enter the cell A1 "date" in cell B1 enter "code" in cell C1, enter the "Purchase Units" in cell D1, enter "Model" in cell E1, enter "quantity purchases", in the "F1 enter the cell," Price "in cell G1 enter" total. "
2. To create the code sheet
Sheet2 worksheet to create purchase units of the code table is to click the Sheet2, cell A1 enter the "code" in cell B1 enter "Name of purchases," in cell A2, enter "A "In cell B2, enter" Electrical and Mechanical Technology and Trade Co., Ltd. Shanghai Branch Coal Coal hydraulic and pneumatic technology center. " Input by the same methods were the names of all purchases of units and their corresponding code (the official holiday has 49 units).
3. To achieve fast data input
Click worksheet Sheet1, in A2, A3, A4 ... ... Enter the appropriate cell within the date, in the B2, B3, B4 ... ... cells enter the appropriate units within the code, D2, D3, D4 ... ... within the cell Enter the appropriate product type, in the E2, E3, E4 ... ... enter the cell number of the appropriate product purchases, in F2, F3, F4 ... ... Enter the appropriate cell products within the unit, within the cell in G2 enter the formula " = E2 * F2 ", enter in C2 cell function" = VLOOKUP (B2, Sheet2! $ A $ 2: $ B $ 50,2,0) ", C3 cells with a mouse click the fill handle and hold the bottom right corner downward drag to copy the formula, then in the "Purchase Unit" within each cell under have all entered the Name of the corresponding purchases. Drag down the same way G3 cells fill handle to the bottom right corner.