That's very helpful.
The target word could actually be in one of two columns, but I can do the
custom autofilter you suggested twice, once on each column, and get managable
results.
Thanks

"Barb Reinhardt" wrote:

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.