VBA code to loop through a table & show only rows that contain search results

Hi all!
I almost know nothing about coding or VBA/I found that the hard way! hahaha!. Therefore, any help/idea will be super appreciated!
in cell "b1", the user will insert a string as a search inquiry. the purpose of that is to search a table ("gloss." located in the same sheet) for all cells that their values equal "*"&b1&"*" then only show the rows that contain those cells while hiding the other rows. also, when "b1" is empty, all rows in table "gloss." should be unhidden. I know that there should be a loop involved in the code. However, I could not produce any working code so far. I am starting to think, am I too rookie or that is indeed so hard in excel?!

Thanks a lot for all your thoughts & ideas & willingness to help!

And drumroll...Sample file?

There we go...Now for a explanation and example...
You say cell B1...Where...And give an example of string entry and where one would need to find this entry...Which column...More than one column?

Try this...

Please Login or Register  to view this content.

Glad I could contribute...tx for rep +