Copy Filtered Data with Automatic Updates

[Mark_B670]

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 data, etc.

Any help is appreciated.

[#2]

@Mark_B670 

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.