Macro/VBA to move specific data from one column to another (without duplicates)

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

Hi Jeremy
- are your words always separated by spaces, or are there also other characters ( , ; - )
- when you say "move", do you want the word deleted from column A as well as added to column C, or do you want to leave A unchanged and copy the reduced text to column B (as your example suggests)?
cheers
Nicky

Hi

try this

it deletes any red text from used cells in column A and inserts the deleted text into the same row in column C

it assumes your "red" is pure red ie RGB(255,0,0). If not, you may need to tweak it to refect the shade of red you use.

Please Login or Register  to view this content.

if you don't want to delete red text from column A, remove this line:

Please Login or Register  to view this content.

Hi NickyC, there are no characters used, just spaces between the words.

The example (screenshot) doesn't have any text in column C. The red text doesn't need to be deleted from column A, just copied into column C with no empty cells.

Does that make sense? see screen shot below of the result i would like the macro to achieve

screenshot2.png

Hi Jeremy
try this instead:

Please Login or Register  to view this content.

@NickyC

Hi NickyC, i've tried running the new Macro you provided (thank you by the way) but nothing seems to happen

Hi NickyC

Apologies, ignore my last post, it works perfectly! thank you so much for your help I really do appreciate it!