There is an internet spreadsheet that I pull into a local spreadsheet
to reconfigure for my own use.

Their categories are defined like:
OtherAnimals,FarmKitchenware,cows,castiron
NEWoct2nd_7th,deer

I would like to be able to pick out the first word before the comma
(unless the first word contains 'new', then I want the second word) --
then I want to populate with my own categories.

If there is a 'special word' like "castiron", I want that category to
override all others. I have about 6 or 7 "special words" that should
override whatever is in their category field.

There are about two thousand items on their spreadsheet and they have
to be pushed into my 388 categories.

I've got a list of "MY" categories on a separate sheet in my workbook.
I've been sorting on their categories and then cutting and pasting
which works fine for the first time. But, their spreadsheet updates
sometimes daily, sometimes several times a week -- which would mean
that every time I pull down an updated version of their spreadsheet, I
would have to re-categorize.

I have no control over the format of the internet spreadsheet --
different company.

Thanks for any suggestions.

Barb