S
spirosu
Is there a way to do the following:
Sheet 1 Column A has an autofilter. When an item is chosen, is it
possible for it to trigger an action in another sheet?
The action would be to find the same item in Sheet 2 Column A as many
times as it occurs and then hide everything else that does not match
(by hiding the rows that the non-matching items appear in).
Sheet 1 Column A has an autofilter. When an item is chosen, is it
possible for it to trigger an action in another sheet?
The action would be to find the same item in Sheet 2 Column A as many
times as it occurs and then hide everything else that does not match
(by hiding the rows that the non-matching items appear in).