How Excel Workbooks are merged

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: