I understand the concept of applying filters to different sheets, the thing here is about formatting filter card... by default when you click show filter you get this setting:
1. Multiple Values (List)
2. All Values in Database
I want a different template of filter to apply each time I click show filter, like this:
1. Multiple Values (dropdown)
2. Only Relevant Values
Hi Darko Nikolic ,
It seems you missed something , why do you want to show this filter in all other sheets ? The reason why we are using "Apply to worksheets " is that we want to control this filter option from anyone of the sheets .
i.e. If you will select a particular year on any sheet ,in all other sheets that same year will be selected .When you want to filter next year just select any year you want to and you will be selecting that same year in all other sheets .
Please check this functionality .
Please mark it right and helpful if this serves your purpose ,so that others can also get benefited .