Find all occurrences, selecte entire rows, copy entire rows

[gregp73]

I feel like this has or should have been asked a million times, but I can't find the answer.

I'm searching a particular column of 10,000+ rows for a word.

It finds all instances. I hit ctrl A, and all of those cells are selected... great. Now what can I do?

I need to select the entire rows of these occurrences and then copy those rows to anywhere else.

Can someone please explain how this is done?

Thank you!

 

[Aladin Akyurek]

Try adapting the set up discussed in:

http://www.mrexcel.com/forum/excel-questions/307832-multiple-vlookups.html#post1511354