Hi Friends,
Did search on this forum for my solution. But did not find a suitable one.
Here is what I would like to get it from list of sentences.
Here we have to take a look at row 5 contains "entire row" text and row 6, 7 contains "entire rows" and also contains work "quickly". (In attached "sample data" file)
I need macro to get first matched word and move entire rows to another worksheet with sheet name "entire row". So that, I can perform another match in sheet name "entire row" for "quickly" word.
Hope you understand
Sample and results files attached
https://spaces.hightail.com/space/y8fhF9kfYt
Did search on this forum for my solution. But did not find a suitable one.
Here is what I would like to get it from list of sentences.
Here we have to take a look at row 5 contains "entire row" text and row 6, 7 contains "entire rows" and also contains work "quickly". (In attached "sample data" file)
I need macro to get first matched word and move entire rows to another worksheet with sheet name "entire row". So that, I can perform another match in sheet name "entire row" for "quickly" word.
Hope you understand
Sample and results files attached
https://spaces.hightail.com/space/y8fhF9kfYt