Auto Filter

When an auto filter filters out a column it creates a list, and from that list you can choose a specific value to go to and it will bring up all of the same values that you have chosen. Is there a way to get all the values from the filter list and use those values.

Hi,

If you go to Filter > Advanced Filter and select "Copy to another location" and "Unique records only" it will generate a copy of the filter list.

Dave