How Excel queries external data by date area

You can enter a start date in the specified cell, and then enter an end date that automatically searches for the data from the specified file and returns you to the worksheet.

For example, enter the "1996-1-1" date in the specified cell, and then enter "1997-5-1" in another cell, and the datasheet automatically takes the data from 1996-1-1 to 1997-5-1 from the specified database or file to the table.

The specific setup process is as follows:

1. To import the data first, click the menu bar--The data--get the external data--from other sources--from Microsoft Query.

2. Select the data source, Excel files*, OK.

3. The database name is sales data. xlsx, file type xlsx format, click OK.

4. Click Next, until the final step of the Query Wizard, check the data in Microsoft Query or edit the query, OK.

5. Below, let's set up Microsoft Query, click Conditions--Add, set fields, operators, and specify values.

6. Enter the start and end dates and click OK when you are finished.

7. Set up, start importing the data, select the display mode and the location of the data, click the Properties button.

8. See the connection properties of this interface, we do not control the other, directly click the parameters.

9. Parameter name see start date and end date, get numeric value from cell, check the cell value change automatically refresh, OK.

10. We test the most later, enter the starting date, the table data changes immediately, are within the specified range of data.