To filter the list assortment by copying rows that match your criteria to another location of the worksheet, click on Duplicate to a different location, click on inside the Copy to box, after which simply click the higher-left corner of the world where by you wish to paste the rows. https://auto-filter52849.answerblogs.com/33938014/how-much-you-need-to-expect-you-ll-pay-for-a-good-auto-filter