Hi guys,

I am very new to VBA and have a question about creating a macro to do mapping. For example if I have the following list in column A:

Apple
Volvo
Hyundai
Orange
Grape
Christmas
Thanksgiving

Now, I want to convert the items in column A based on the following mapping,
Apple, Orange, Grape --> Fruit
Volvo, Hyundai --> Car
Christmas, Thanksgiving --> Holiday

This is just a simple example, and I am hoping that I can get some help on the start so that I can expand on the macro.

Thank you!
Leon