Forum Discussion
Copy Filtered Data with Automatic Updates
I was wondering if it's possible to copy filtered data (with the header row) to another worksheet. When copied, I want both worksheets to update when I add rows, filter data, delete data, change dat...
Your description seems to point toward a solution using the relatively new FILTER function, which could indeed enable the secondary or derivative sheet to mimic any changes on the primary sheet (other perhaps than a change to the data on which the filter itself is based).
Here's a video that explains FILTER. Here's a text-based resource. You will need Excel 2021 or newer.