I wanted to know how I can get the selected fields in a auto filter.
The idea here is that I want the fields that a user selects from a table, and I program in vba to apply that same filter to other sheet automatically.
Any help would be appreciated!