search multiple worksheets in workbook for keyword then copy entire row to new worksheet

Anthony,

Thank you very much for all your help. The macro works perfectly and does everything exactly how I was trying to get it to. Now on my on time I just need to try to figure out how you got it work like that.


Thanks again. This forum is awesome.

Hello! Was reading the tread and was hoping for some help. I am looking for something a lot this except when it finds the result no matter what column it is in I need the entire row to be displayed. Also If it could display the column headers too that would be cool if possible. The column headers are different on each spreadsheet.

Thanks in advance.