MikeB41
09-27-2011, 09:07 AM
Hi All,
I would appreciate any help with the following:
I have an excel worksheet with approximately 650 rows by 77 columns wide and need to search for approximately 9 columns of key words and then in the 10th which contains problem text I am interested in that has now been qualified by the previous 9 columns on a given row and then create a new worksheet with the 10th text cell containing the word of interest.
I have used some code that was created by mdmackillop # 780 id=780
it works great however it only searches for a single word, when I need it to search for 10 words an the last 10th it returns that cell on the new sheet that was created.
I guess if you could picture using an AutoFilter to search each column (up to 9 columns) that contains the required word in each and when you get to the 10th column searching for the final word.
Thank you,
MikeB41
I would appreciate any help with the following:
I have an excel worksheet with approximately 650 rows by 77 columns wide and need to search for approximately 9 columns of key words and then in the 10th which contains problem text I am interested in that has now been qualified by the previous 9 columns on a given row and then create a new worksheet with the 10th text cell containing the word of interest.
I have used some code that was created by mdmackillop # 780 id=780
it works great however it only searches for a single word, when I need it to search for 10 words an the last 10th it returns that cell on the new sheet that was created.
I guess if you could picture using an AutoFilter to search each column (up to 9 columns) that contains the required word in each and when you get to the 10th column searching for the final word.
Thank you,
MikeB41