How Excel Workbooks are merged

Source: Internet
Author: User

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:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.