Ethen5155
12-18-2018, 03:05 AM
Hello All,
kindly please i need some help to edit my attached macro to met the requirements i need.
there is xlsm file attached (Terms Highlight.xlsm)
in second tab (Terms Keywords) as shown below i put terms keywords as shown below
23433
and in the first tab (Target) i put the all segments which contain words that i need to highlight with the help of the second tab i mentioned above
23434
and i success at that but there are 3 issues i couldn't fix or reach to:
1- i have to put all words in second tab (Terms Keywords) in lower case first and if i didn't it won't color any matching word in the first tab (Target).
2- i need to make the macro skip or exclude the repeated words, for ex. if it found "School" at the first cell and this word exists in the 4th cell then skip it and just color the one in the first cell
3- (The most important edit i want)i need to extract those colored non repeated words to column (C) and put colon (:) after it as shown below to be translated later to another language, and this feature should work well with the cell that contains about three or four extracted words.
23435
Many thanks in advance, and any help will be highly appreciated
Cheers
Post-Link : here (https://www.excelforum.com/excel-programming-vba-macros/1256984-please-need-some-help-to-edit-my-macro-copy-colored-words.html#post5029375)
kindly please i need some help to edit my attached macro to met the requirements i need.
there is xlsm file attached (Terms Highlight.xlsm)
in second tab (Terms Keywords) as shown below i put terms keywords as shown below
23433
and in the first tab (Target) i put the all segments which contain words that i need to highlight with the help of the second tab i mentioned above
23434
and i success at that but there are 3 issues i couldn't fix or reach to:
1- i have to put all words in second tab (Terms Keywords) in lower case first and if i didn't it won't color any matching word in the first tab (Target).
2- i need to make the macro skip or exclude the repeated words, for ex. if it found "School" at the first cell and this word exists in the 4th cell then skip it and just color the one in the first cell
3- (The most important edit i want)i need to extract those colored non repeated words to column (C) and put colon (:) after it as shown below to be translated later to another language, and this feature should work well with the cell that contains about three or four extracted words.
23435
Many thanks in advance, and any help will be highly appreciated
Cheers
Post-Link : here (https://www.excelforum.com/excel-programming-vba-macros/1256984-please-need-some-help-to-edit-my-macro-copy-colored-words.html#post5029375)