I need to categorize a lot of words by certain keywords, then cut each category to a different sheet. Then the rest Words Mix would be the ones can not be categorized by Keywords.
The column A is Words Mix
Toyata customer service
BMW racing car
The second column B is my keywords criteria
I am a newbie to VB and I got stuck at autofilter. I read through previous posts on autofilter in this forum, but still can not find answers. My criteria is not "=" or ">" "<". if there anything to express "contain" in Excel filter in VB?