Yes, that would be real easy, but I still need it to be usable by people with no excel exprience. So basically I need to know how to convert the value of the cell J5 to a string, add two "*"s at each end and feed it to AdvancedFilter's criteria need. Seeing as it requres a range as a criteria, I believe it's going to be difficult, no?