Let's say I have a task list of items that need to be accomplished
| Description | Tasks |
| D1 | T1 |
| D2 | T2 |
| D3 | T3 |
| D4 | T4 |
Each of these tasks really only needs to be done when certain conditions are met.
We can attach each of these tasks to conditions in the same row.
| Description | Tasks | Condition1 | Condition2 | Condition3 |
| D1 | T1 | TRUE | TRUE | |
| D2 | T2 | | TRUE | |
| D3 | T3 | TRUE | | TRUE |
| D4 | T4 | | | TRUE |
(i'd like to hide these columns eventually)
Now another place in the page I have user entry for if the conditions apply
| Condition1 | TRUE |
| Condition2 | FALSE |
| Condition3 | TRUE |
What I want is to be able to filter the Task list dynamically into only activities where the Tasks hit any of the Conditions
For Example, If condition 1, and 3 are true but 2 is false. I would expect to have Tasks T1, T3, and T4 displayed on this list, and task T2 filtered out and not displayed. Task T2 would not display because it requires that Condition 2 be true and is not required for either condition 1 or condition 3.
| Description | Tasks | Condition1 | Condition2 | Condition3 |
| D1 | T1 | TRUE | TRUE | |
| D3 | T3 | TRUE | | TRUE |
| D4 | T4 | | | TRUE |
What is the easiest way to do this? Would this have to be done via VBA?
