June 11, 2019
welcome every one
I try to make a macro that repeats the sentence in the current cell in column C number of times equal to the number of words of the sentence below the current cell minus one; such as: a sentence of three words we repeat twice.
Then we type the example words in column B so that each cell has a word in front of each example against duplicate examples with parentheses around the word that is identical to the column B, as shown in the images.
please help, thanks in advance.
October 5, 2010
Your description and the images you supply don't match up so I'm finding this a little confusing.
There is no Col C shown in the images.
Where is the example sentence typed?
Are the words in Col A typed in by you, or extracted from the sentence?
Do you need the words colored? You don't mention that but the images show them in green.
Please supply workbook with the sentences in it and examples that match up to your description of what you want as a result.