ABOUT AUTO FILTER

If you filter, enter a reference for the copied column labels while in the Copy to box. The copied rows will then contain only the columns for which you copied the labels.You'll be able to filter based on possibilities you make from a listing, or you can generate unique filters to focus on exactly the data you want to find out.Remember to preserve