THE SINGLE BEST STRATEGY TO USE FOR AUTO FILTER

Once you filter, enter a reference to your copied column labels while in the Copy to box. The copied rows will then incorporate only the columns for which you copied the labels.Thus, only specific rows are exhibited, though other rows which will not fulfill the filter problem usually are not displayed. Communities assist you to inquire and answer