So I've spent a few days trying to sort this out, but am not having much luck. On the surface this seems to be an easy enough premise. I have table of data. I need the table to hide certain rows depending on what the user punches into the search box. If they search for "Sam", any row not including "Sam" is hidden. However, best case scenario would be that the user could punch in more than one variable, and it would filter even further - "Sam 2011" etc. I've found vba scripts that come close to what I'm trying to achieve... but nothing close enough to superficially edit. Any help/direction would be greatly appreciated!Sample.xls