If the word in question is in the same column of data, you could use
autofilter to find the word.

Select the headers for the columns you are reviewing and
Data - Filter - Autofilter
On the down arrow that's displayed at the top of the column in question,
select CUSTOM and show rows where "Column Name" CONTAINS "word"

"Denys-mark" wrote in message
...
I want to find all rows in a worksheet that contain a particular word, and
copy those rows into a blank new worksheet. Thanks for advice.