Copying results of a Find All

[SandsB]

I have 50,000 rows of data. If I do a Find All for the phrase "donation" Excel returns about 50 cells. How can I copy just those rows into another file?

 

[Weaver]

would the phrase appear in the same column?

If so, you could use filtering instead, by choosing 'custom' and picking the option 'contains' before defining your criteria. Then you can select, copy and paste the visible rows into another sheet. If the phrase could appear in any column then it's still possible, just a little more complicated.

An alternative might be to use vb programming to examine your data, select, then copy the required rows.