LITTLE KNOWN FACTS ABOUT AUTO FILTER.

To filter the record range by copying rows that match your criteria to another location on the worksheet, click on Duplicate to another site, simply click within the Copy to box, and after that click the higher-still left corner of the realm in which you need to paste the rows.Insert at the very least a few blank rows above the listing variety whic