Hello People,
I have a workbook with loads of worksheets in. There are lists of keywords in cols. A-I. I need to combine these words to make all possible strings of words in certain combinations.
EG: in col: J the title is: C-A-E, And in this column I need all the combinations of words in columns C, A and E.
Theit are other columns with different combinations. can I get excel to look at the column name and then make the selections of col.s to combine?? I would like to make a macro to do it really.
The problem is all the worksheets are different, Any help appreciated. I am currently using DigDB, and it is ok, but still takes too long fr me!!
Bookmarks