Hi all,
First post here, I have tried searching for a solution for what I need but haven't found anything yet.
I have a set of 12 columns, each one linked to a ActiveX Check Box. Whenever a box is checked, the corresponding column filters on criteria "X" (there are only blanks or X's in any of the columns).
When two boxes are checked it will filter both columns but will only display results where there is an "X" in both of the columns.
Is there any way to manipulate the AutoFilters such that [if boxes 1 and 2 were checked] it would show all instances of "X" occurring in either column, rather than just where it occurs in both?
Super grateful for any help with this.
Alex
First post here, I have tried searching for a solution for what I need but haven't found anything yet.
I have a set of 12 columns, each one linked to a ActiveX Check Box. Whenever a box is checked, the corresponding column filters on criteria "X" (there are only blanks or X's in any of the columns).
When two boxes are checked it will filter both columns but will only display results where there is an "X" in both of the columns.
Is there any way to manipulate the AutoFilters such that [if boxes 1 and 2 were checked] it would show all instances of "X" occurring in either column, rather than just where it occurs in both?
Super grateful for any help with this.
Alex
