Word search / letter filter

[CascadeDiver]

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.

 

[Rijnsent]

Hi CascaseDiver,
any chance you can explain your thoughts a bit better? In your mockup I see some tables at the bottom, but I miss the connection with what you're trying to achieve. Where would you be typing your filter criteria? Do you mean you want to type e.g. "G" in cell G2 after which the table at the bottom left should filter with that criteria?

 

[CascadeDiver]

Hi CascaseDiver,
any chance you can explain your thoughts a bit better? In your mockup I see some tables at the bottom, but I miss the connection with what you're trying to achieve. Where would you be typing your filter criteria? Do you mean you want to type e.g. "G" in cell G2 after which the table at the bottom left should filter with that criteria?

You are correct

If I were to type "G" in G2 the table to the left would filter by that criteria. Additionally, the other remaining Columbia is the left table as well as the other two tables would filter OUT the letter "G". That would leave the letter "G" in the first word and in the letter 1 position only

That is to say, unless I also designate the letter "G" in another spot, either in the same word or another.

If there is a different way to design this I could go down that route instead.