Data Classification Using Keywords with VBA

Hi Experts,

Ok, So I have column K that contains a long text description, and I have thousands of cells like this.
So what I'm trying to do is to categorize each cell by main keywords.

B.W it should be possible to have a few keywords for each description. Is it possible for one keyword category to supercede the others, what are my options?
-----

I have set of keywords under "Categories" Tab, I've already started the codes, it is working, but shows multiple categories when multiple keywords are found under column K.

PS:
I am also planning to write a code for column M to fill sub-categories based on column K keywords too.

Help please.

up for this.

thanks everyone for taking time to view my post. still waiting for help.

up...


B.W it should be possible to have a few keywords for each description. Is it possible for one keyword category to supercede the others, what are my options?

help please.

help ........