Two excel sheets, sheet1 and sheet2, update the data of one field in the sheet1 table to the data in

The meaning of your table should be that the serial number of sheet2 contains all the serial numbers of sheet1. Sheet1 only has a partial serial number for sheet2.

This can be done using the vlookup formula.

The serial number column is defined as column A.

In the quantity column of Table 1, enter the following formula in the first cell:

vlookup(a:a,sheet2!a:b,2,0) can match column A in Table 1 and column A in Table 2 first, and if the sequence number is the same, the data in column 2 of Table 2 is filled in Table 1.

Summary. Enter in cell b3 of sheet2.

sheet1!a1

The formula means: by the equals sign, the B3 cell of the current sheet2 worksheet is referenced to the cell under the table name after the equals sign, when the data of cell A1 of sheet1 changes, the data in cell B3 of sheet2 also changes.

The equals sign in the expression, the name of the referenced table, and the referenced cell are all indispensable.

See the attached drawings for examples.

When the data of cell A3 in Sheet1 contains any cell data in Sheet2, how to automatically display the corresponding content of column A in Sheet2 in Sheet1 B3 cell.

Hello Hello Hello

When the data of cell A3 in Sheet1 contains any cell data in Sheet2, how to automatically display the corresponding content of column A in Sheet2 in Sheet1 B3 cell.

Enter =sheet1!, cell b3 in sheet2The formula A1 means: through the equals sign, the B3 cell of the current sheet2 worksheet is referenced to the cells under the table name after the equals sign, when the data of the A1 cell of Sheet1 changes, the data in the B3 cell of Sheet2 also changes.

The equals sign in the expression, the name of the referenced table, and the referenced cell are all indispensable. See the attached drawings for examples.

Select all sheet1, insert, pivot table, select new worksheet.

Drag the name above to the row, and the amount to the value. Point value triangle symbol, field setting, select sum.

If you drag and drop both the name and the amount in the value **, the point value triangle, the field setting, the sum of the amount selection, and the count selection of the name. You can also count the number of consumptions.

sheet2!a1=sheet1!a1

Then add sheet2!A1 pulls right and then pulls down to the entire data region.

It is recommended to solve it with macros.

1. Preparations:

1.Storage Sheet2 - Select A2

2.Import to Input-sheet1 and select a2:e2<>

2. Record macros. Tools - Macro - Record New Macro - OK.

Right-click on Sheet1 A2:E2 - copy and click Sheet2 to paste directly (note that it is a direct paste, do no other operations) and paste A3 on a stand-alone machine

Import to sheet1, select a2:e2, clear the data and stop recording.

3. Specify the macro.

To create a new arbitrary shape, right-click - Specify Macro - OK.

Fourth, run macros.

After entering data in Sheet 1, click Sheet A2 and click Graph.