EXAMINE THIS REPORT ON AUTO FILTER

To filter the listing assortment by copying rows that match your requirements to a different space on the worksheet, click on Copy to another spot, simply click inside the Duplicate to box, and then click the upper-left corner of the realm the place you need to paste the rows.The information involves four blank rows above the record selection that