Excel: How to Pull Data from Another Sheet Based on Criteria


You can use the Excel Advanced Filter function to pull data from one sheet into another sheet based on criteria.

The following step-by-step example shows how to use this function in practice.

Step 1: Enter Data into the First Sheet

First, let’s enter the following dataset into the first sheet of an Excel workbook:

Step 2: Define Criteria

Now suppose we would like to pull each of the rows that contain “Mavs” in the Team column into Sheet2.

To do so, we can define this criteria in Sheet2:

Step 3: Pull the Data from the First Sheet

Next, we can click the Data tab and then click the Advanced Filter button:

In the new window that appears, click Copy to another location and then fill in the following information:

Excel pull data from another sheet based on criteria

Once you click OK, the rows from Sheet1 where the Team column is equal to “Mavs” will automatically be pulled into Sheet2:

Notice that all three rows where the Team column is equal to “Mavs” have been pulled from Sheet1 into Sheet2.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

Excel Advanced Filter: How to Use “Contains”
Excel Advanced Filter: How to Use “Does Not Contain”
Excel Advanced Filter: Display Rows with Non-Blank Values

Leave a Reply

Your email address will not be published.