ABOUT AUTO FILTER

Whenever you filter, enter a reference on the copied column labels in the Duplicate to box. The copied rows will then include things like just the columns for which you copied the labels.You could filter based on choices you make from a list, or you can create unique filters to center on exactly the information that you would like to determine.To s