Download the featured file here (including VBA code): https://www.bluepecantraining.com/excel-copy-filtered-data-to-another-worksheet-automatically-advanced-filter-with-vba-filter/

In this Microsoft Excel video tutorial I demonstrate how to copy filtered data to another worksheet automatically. I explore two methods.

METHOD 1: Use the Advanced Filter with VBA
The advanced filter allows you to copy filtered results to another worksheet but it doesn't update automatically if you change your data or criteria. You can however add VBA code to the filter which will update it automatically.

METHOD 2: Use the FILTER Function (Excel 365)
If you have Excel 365, you can use the FILTER function to copy filtered data to another worksheet. This method does not require any VBA and will update automatically when the data or criteria is changed.

Table of Contents:

00:00 - Introduction
00:15 - Using the Advanced Filter
02:04 - Auto Update the Advanced Filter with VBA
04:14 - Using the FILTER function
------------------------