Excel find text and copy rows

D

Denys-mark

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.
 
B

Barb Reinhardt

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"
 
D

Denys-mark

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
 
Top