For the sake of universal usage and simplicity, this is how I would do it.
1) Add a new column out to the right of your data for a helper column. used column O. The first formula in O8 is:
=ISNUMBER(MATCH("*" & $F$1 & "*", A8:M8, 0))
...copied down.
2) Unmerge the big cell at the top.
3) In E1 put the word SEARCH>>
4) Right click the tab and select VIEW CODE to open the sheet module, the drop in this event macro which will watch cell F1 for any search term you enter:
5) Now you're ready, type any string you want, long or short, into cell F1 and the sheet will instantly filter to show all the rows that have that string anywhere on their row.
To see all rows again, simple clear cell F1.
Bookmarks