Search string from multiple sheets

Hi All,
I have a small requirement where I need to search quite a few excel sheets for a particular string. Once I find it. I need the compete row to be copied to the search file.
I have attached the files and search file.
• All the files will be saved in the same path
• All are excel files
• Few files may have multiple sheets
• Files will keep increasing by one every month
Hope you can help me with this

See: venkatkumar1111_Search.xlsm
Place this file with the other files in a folder.
Click on search button.

I placed the results in a msgbox.

But you can place the results in your worksheet. (It wasn't clear to me where you wanted this information placed.)

Please Login or Register  to view this content.

Thanks a lot Steven for your solution....!!

Its working perfectly fine ...

Could you please help me to modify it a bit..


I created a form . I want to get the form up when we click on search
When we input the data in the form and select "find"
We should be able to get the results in the bottom box of the form.


Attached is the updated folder.

Could you please help me with this...

Thanks in advance
Venkat