Рет қаралды 1,193
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.
🎓 LEARN MORE in my Excel tutorials: excelkid.com/
🔔 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 use the FILTER function to copy filtered data to another worksheet. This method will automatically update whenever the data or criteria are changed.
#exceltips #exceltutorial #excel