I have attached a workbook in which I want to reset the wildcard match filter based on its dependent selection.
To say -
If the user selects - 'All' in Class filter, and types in "cl" in the wildcard search filter, the output will be
And then, user select '3' in Class filter, the output gets vanished, as the text 'cl' is still available in the wildcard match filter.
So, is there a way to get the wildcard match filter blank, when the user changes the selection in the Class filter?
Retrieving data ...