Hi, I am trying to figure out how to automatically refresh an advance filter (no manual running of macro), when some of my filter criteria changes, provided the change is indirect - first changes another field (named "interface"), that then triggers the change in one of the criteria which calculates to either "True' or "False".
My final goal is when the file user changes field "Interfaces" (which is a of list type with 3 possible values), which produces a change in the criteria for the advanced filter, the latter to refresh itself automatically. Tried a few things but neither worked. Any ideas?
My final goal is when the file user changes field "Interfaces" (which is a of list type with 3 possible values), which produces a change in the criteria for the advanced filter, the latter to refresh itself automatically. Tried a few things but neither worked. Any ideas?