How do I use 'Find All' and copy the entire row

[ldavis]

I want to do a 'Find All' and then copy the entire row of each finding into
another workbook

 

[Don Guillett]

Instead why not try
data>filter>autofilter>filter on the desired>copy