how Excel workbooks are merged
For example, in the following figure, to merge four branches of data into a table, some people say that non-VBA can not solve.
I'm here to say out--.
Microsoft Query is a perfect solution, and you can also implement Automatic updates when data is added and deleted.
The following figure simulates the payroll of four companies, which are stored in different workbooks:
Let's take a look at how to summarize the data from the four workbooks into a single workbook:
Open the Summary workbook, click the Data tab, and then from other sources → from Microsoft Query
The following figure:
In the Select Data Source dialog box, select the Excel file database and remove the check from the Query Wizard. The following figure:
In the Select Workbook dialog box, first select the drive that the file is stored in, and then locate the folder and double-click. Double-click any file in the file list, as shown in the following figure:
In the Add Table dialog box, double-click the name of the worksheet that contains the data source, and then click the Close button. The following figure:
This is where you enter a new Microsoft Query window.
In the Query window, double-click the * number in the datasheet to add all the fields to the list.
Click the "SQL" button on the toolbar to open the SQL dialog box: