Filter Rows - One Value in A Range of Cells

[Ark68]

I have a database with a range of cells, F13-O91, each populated with a variety of names.

What I wish to do with a macro, is filter all the rows in which a user entered name in B2, appears in the above range of cells.

 

[chuckles1066]

A slight tweak of this should get you close to where you want to be:

http://www.mrexcel.com/forum/showthread.php?t=541766

 

[Ark68]

Thanks Chuckles, I was hoping it wouldn't be so complicated LOL. Going to have to digest that thread a bit and see how/where I can adapt it to my situation.

Cheers