Hi,
I have 2 filters in my Report Filter field. Is there a way to minimise the selection of Filter #2 when I choose a selection in Filter #1? At the moment, Filter #2 returns everything that is available and I only want it to return what’s available after selecting something in Filter #1.
Does anyone know if this is possible?
Any help would be gratefully appreciated.
P.S. I have no working knowledge of VBA
I have 2 filters in my Report Filter field. Is there a way to minimise the selection of Filter #2 when I choose a selection in Filter #1? At the moment, Filter #2 returns everything that is available and I only want it to return what’s available after selecting something in Filter #1.
Does anyone know if this is possible?
Any help would be gratefully appreciated.
P.S. I have no working knowledge of VBA