How to Copy Filtered Data to Another Worksheet in Excel - Advanced Filter and FILTER function

In this tutorial, I'll show you how to copy filtered data to another Worksheet in Excel using the advanced filter and the FILTER function.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

🎁 SHARE this video and spread the Excel love.

Chapters:
00:00 Intro
00:05 Using the Advanced Filter
00:49 Copy Filtered Data to another Worksheet using the FILTER function

Method 1: Using the Advanced Filter
The advanced filter lets you copy filtered results to another worksheet, but it doesn't automatically update when you change your data or criteria.

Method 2: Using the FILTER Function (Microsoft 365)
If you have Microsoft 365, you can copy filtered data to another worksheet using the FILTER function. This method will automatically update whenever the data or criteria are changed.

#exceltips #exceltutorial #excel

[roberttaylor]

Works fine in excel version 2409 Microsoft 365 apps