Hello

I have a column of data that I want to classify in an arbitrary number of user defined categories, each category based on a number of user defined keywords.
The column looks something like that

JoesSupermarket
MikeFuelStation
BusTicketOffice
JimsPub
GroceryStore
BasketBallMatch
JanesMarket

Ideally, the user should be able to classify all the entries containing the word "market" or "grocery" into the category "Food", the words "Pub" or "Basket" into "Fun" and "Bus" or "fuel" into the category "Transportation".
I know how to process the strings and separate the categories, but I need help on how to manage the "user defined" part.

So far, I created a "categories" worksheet, where every column as a header (Food, Fun, Transportation) and below every header there's a list of keywords to be used.
How exactly do I use this in VBA though? I could make somehow a triple for loop using ranges, but it sound very complicated and inefficient to me.
I would need something like a collection of collection, or maybe some kind of structured data type?

Any suggestion on how to approach this?