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
Words Mix
Cars Honda
Trucks Honda
Honda SUV
Honda sedan
Honda style
Honda price
Honda review
Honda discount
Toyata brand
Toyata customer service
Toyata dealership
BMW cars
BMW racing car
BMW SUV
BMW sedan
BMW z3
BMW price
The second column B is my keywords criteria
Catagory
Honda
Toyata
BMW
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?
thank you