Find specific text in a cell within a worksheet and copy the entire row to another sheet

Hello,

I am working with a sheet that is too large to filter and just copy/paste. I need to run a macro that will search for a specific word in column B (cells in column B may contain more than one word) and then copy that entire row into another worksheet. This needs to pick up every instance of this occurrence (in some cases more than 200 times).

For example, one of the words I may be looking for is "growth" while the cell(s) may contain "organic growth." I need all rows that contain any occurrence of "growth" in column B pasted to another sheet.

Thank you!!

Maybe:

Please Login or Register  to view this content.

Thank you for the quick reply, sorry that mine wasn't as prompt. This is actually not returning anything when I run it. I changed the range to match what I needed and the sheet names to correspond with what is in my file, but nothing is being generated.

It worked with I tested on some data I created. Can you attach a file with some sample data? Preferably one where you still are having problems. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.