Hi,

I have a requirement where I want to search for a string in a list of files present in a folder. The excel sheets will have data in different sheets. When i search for a string, if the string is found then the result should be populated to a different excel with the excel sheet name and sheet name in which data was found. If the string is not found then it should pop up a window saying search did not yield any result.