About auto filter
To filter the list assortment by copying rows that match your requirements to a different area with the worksheet, click on Duplicate to a different spot, click on inside the Copy to box, then click on the upper-remaining corner of the world wherever you should paste the rows.By contrast, after you click on a Microsoft-supplied advert that appears