Autofilter

Hi Michael

Thank you for your question

Rather than using the autofilter, you may be better using the Advanced filter, as this allows you to copy the filtered data to a new location

To do this

Create your criteria range, with column headings and criteria for the filter

Select a cell in the list and go to Data-Filter-Advanced Filter

Choose to copy data to new location and specify target cell

Click OK and your filtered list will be copied to that new location

Hope this is useful

Regards

Stephen