Search a word in entire workbook and copy paste the row containing that word to new sheet

I am a beginner in VBA. Please help me to write a code to make the following workable:
1. On a button click, it will prompt the user to enter a word to be searched in the entire sheets of the workbook
2. As it finds the word it should copy paste the entire row containing that word to a the sheet containing that button
3. If it is getting that word multiple times, it can copy paste all the searched rows.

Thanks in advance.

Can this help?

Please Login or Register  to view this content.

Or this..

Uses FindNext so it doesn't need to loop through so many values..

Add a Command Button to sheet1 and insert this code..

Note: This code assumes your first sheets name is "Sheet1".. change that in the code if needed.

Please Login or Register  to view this content.