Retrieve the criterion of an automatic filter
lijert
-
f894009 Posted messages 17417 Registration date Status Member Last intervention -
f894009 Posted messages 17417 Registration date Status Member Last intervention -
Hello,
I am working on Excel 2016 and I currently have an Excel file with data formatted as a table ("Format as Table").
The columns therefore use an automatic filter, which I would like to keep.
However, I would like to retrieve the selected filter criterion and place it in a cell so that I can use it for other purposes.
Thank you in advance for your responses, and I am available for further details.
lijert
I am working on Excel 2016 and I currently have an Excel file with data formatted as a table ("Format as Table").
The columns therefore use an automatic filter, which I would like to keep.
However, I would like to retrieve the selected filter criterion and place it in a cell so that I can use it for other purposes.
Thank you in advance for your responses, and I am available for further details.
lijert
