CascadeDiver
Board Regular
- Joined
- Apr 10, 2020
- Messages
- 66
- Office Version
- 2016
- Platform
- Windows
I'm just playing around here but I wanted to try and make a dynamic filter across multiple tables.
The idea is to filter letters from other column in different tables.
If I type and "X" any letter row in any word then all other tables filter all columns by that letter, except for the designated letter column. Allow for double letters in a word and using same letter more than once if designated
Power query or VBA is formulas are all fine.
Just as a quick way to organize my thoughts I started creating tables and letter designated down.
The idea is to filter letters from other column in different tables.
If I type and "X" any letter row in any word then all other tables filter all columns by that letter, except for the designated letter column. Allow for double letters in a word and using same letter more than once if designated
Power query or VBA is formulas are all fine.
Just as a quick way to organize my thoughts I started creating tables and letter designated down.
