I'm not sure how to go about creating this Macro so I would really appreciate it if someone could help me. I need a Macro/VBA that moves any word in red from column A into column C as a list.
However if the same word is highlighted more than once in column A, I only want that word to go into column C once (no duplicates)
uRpAN.png
Any help would be appreciated,
Thanks
Jeremy
Bookmarks