Ethen5155
03-10-2019, 11:02 AM
Hello and hope all is well.
please i'm just need a little small help to improve this code.
there is file attached i use to color specific words is first tab column (A)
23877
using a words list at second tab column (A)
23878
then add those colored words on first tab column (C) with followed colon (:)
23879
The final touch which i need to help me about is to insert each definition from second tab column (B) after each colored word on first tab column (C)
23880
i have attached the file that contains code, and i hope if someone can help about that and keeping in mind two points:
1- this code excludes (skips) repeated words in column (A) first tab if found and doesn't copy it to column (C) and i want to disable this feature. for ex. if found word (Test 1) in cell A3,A7,A10 it will copy it just one time at C3 but what i want is to copy it in C3,C7,C10
2- second point if there are two values in the same cell column (A) like (Test 1) and (Test 2) i want them to be copied to column (C) even if they copied before.
P.S: final result in column (C) if is colored like screenshot it will be very highly appreciated.
Cross Posted link : here (https://www.excelforum.com/excel-programming-vba-macros/1267814-please-help-to-modify-my-code.html)
Thanks in Advance dears.
cheers
please i'm just need a little small help to improve this code.
there is file attached i use to color specific words is first tab column (A)
23877
using a words list at second tab column (A)
23878
then add those colored words on first tab column (C) with followed colon (:)
23879
The final touch which i need to help me about is to insert each definition from second tab column (B) after each colored word on first tab column (C)
23880
i have attached the file that contains code, and i hope if someone can help about that and keeping in mind two points:
1- this code excludes (skips) repeated words in column (A) first tab if found and doesn't copy it to column (C) and i want to disable this feature. for ex. if found word (Test 1) in cell A3,A7,A10 it will copy it just one time at C3 but what i want is to copy it in C3,C7,C10
2- second point if there are two values in the same cell column (A) like (Test 1) and (Test 2) i want them to be copied to column (C) even if they copied before.
P.S: final result in column (C) if is colored like screenshot it will be very highly appreciated.
Cross Posted link : here (https://www.excelforum.com/excel-programming-vba-macros/1267814-please-help-to-modify-my-code.html)
Thanks in Advance dears.
cheers