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.

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" <Denys-(E-Mail Removed)> wrote in message
news:454E77FB-B62E-4425-9671-(E-Mail Removed)...
>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.

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" <Denys-(E-Mail Removed)> wrote in message
> news:454E77FB-B62E-4425-9671-(E-Mail Removed)...
> >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.
>
>
>