Share via

Display a filtered worksheet on a different tab

Anonymous
2016-06-24T07:45:36+00:00

On one tab we have a table with hundreds of records and where additional records are added daily.  We use filtering on this worksheet. 

Now we are creating a separate worksheet to give us a daily snapshot of this data where we can filter on the other tab, but have only the results and only certain columns display.  Is there a way to do this?  We don't want to change the format of the primary tab. 

We're using Excel in Office 365 for Small Business on Windows 10. 

Thank you for any help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-29T08:46:37+00:00

    Hi Lee,

    Based on your description, you would like to create a filter in Workbook B to display data in Workbook A. You can follow the steps below to achieve it via Advanced Filter.

    1. Open Workbook A and Workbook B on your PC at the same time.
    2. You can rename the Worksheet 1 in Workbook B Output.
    3. In Workbook B, go to Data> Sort & Filter> select Advanced.
    4. In Action, choose Copy to another location.

    1. In List range, go to Workbook A, and select the range of data.
    2. In Criteria range, go to Workbook A, and select the range of filter condition.

    1. In Copy to, go to Workbook B, and select the range of blank cells, where you would like to display the data.
    2. Click OK and the filtered data would display in Workbook B.

    Regards,

    Yoga

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-08-28T17:52:32+00:00

    Hello Fraser,

    I needed to filter the data in a different workbook, not a different worksheet.  Therefore, I learned I could define an area on a worksheet as a data table, which assigns it a name.  Then I was able to insert that table into a tab in a different workbook and use the Data, Data Connections, Refresh to update the data.  In the remote workbook, I can filter on the data in various ways. 

    Lee

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2016-06-26T09:46:53+00:00

    Hi Lee,

    Does the answer above address your questions?

    Regards,

    Fraser

    0 comments
  4. Anonymous
    2016-06-24T09:43:16+00:00

    Hi Lee,

    After doing some researches, I found that we can use Advanced Filter to do so: Using Excel's filter function on a different sheet than the data is located.

    For more information about Advanced Filter, you can refer to this article: Filter by using advanced criteria.

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the download you receive from the third-party linked sites or any support related to the download or the downloaded technology. If you need support relating to the third party technology, please contact the manufacturer directly.

    Regards,

    Fraser

    0 comments