To filter the record range by copying rows that match your criteria to a different area of the worksheet, click Duplicate to another area, click in the Duplicate to box, after which you can click on the upper-still left corner of the realm exactly where you would like to paste https://autofilter41727.answerblogs.com/33938874/the-smart-trick-of-auto-filter-that-no-one-is-discussing