Keyword Search -> Copy and Paste VBA Macro Issue

Hello all!

I'm trying to search a dense worksheet for certain keywords, then select the entire row in which those keywords appear, and then copy them to a new sheet. The number of keywords is above 10, and sometimes one keyword will appear in several rows, so I would need to copy all of the rows in which it appears.

I see a few options to do this:

1.) The 5-line search and cut/paste operations could be performed and looped (i.e text cut and pasted) until the keyword is no longer present, when the macro would then move on to the operations for the next keyword (searching, copying and pasting its row)
2.) If any of you know how to manipulate the code to simply perform these 5-line operations 10 times (i.e 10x loop) before continuing to the next set of 5-lines that would be IDEAL.
3.) My current search to "find" the keyword could be changed into a "find all" function, which I havent been able to do but which would be THE IDEAL SOLUTION IF POSSIBLE.

Please help, I know I seem helpless but I'm in desperate need here. I'm very new at this so my code might be a bit foolish.

Please Login or Register  to view this content.

---------- Post added at 06:20 PM ---------- Previous post was at 06:11 PM ----------

Also if anyone wants/needs more information to help me out just ask and I'll be happy to oblige!

---------- Post added at 06:37 PM ---------- Previous post was at 06:20 PM ----------

Also the current error message is a compile error: Loop without Do