Referral Macro

[X_man123]

I need help with writing a macro that will take a list of keyword criteria and group referrals into groups, this group name should be appended at the end of the data table. The macro should be customizable, to easily add keywords for a referral group and to add additional referral groups.


Step 1) Get macro to group referrals based on current referral mapping
Step 2) Add additional keywords


Additional points for a user interface to review or add keywords easily


Regards,

 

[ranman256]

so enter GROUP and the key words , then store:
GRP, KEYWORD
moon, planet
moon, orb
moon, rock

???

 

[X_man123]

so enter GROUP and the key words , then store:
GRP, KEYWORD
moon, planet
moon, orb
moon, rock

???

I am new to vba coding, can you please give me an example of how I can achieve that?