A REVIEW OF AUTO FILTER

Once you filter, enter a reference for the copied column labels inside the Duplicate to box. The copied rows will then involve just the columns for which you copied the labels.It's yet another way of choosing Auto filter. Nevertheless, if you select a number of cells, the filter will probably be utilized only to All those cells. Hence, be cautious