Dear all,

I would be grateful if someone could provide me with the code for this problem, or point me in the right direction. I’ve tried a few codes but I haven’t managed to find a solution.

I have a list of words in column A of Sheet 1. I would like to search for each of these words in multiple Excel files which are saved in one folder. If any of the words are found in any of the Excel files, I would like to know in which file it was found. In Sheet1 the result would look like this:

Column A —- Column B
Peter        —– File path/file name
John        —– Not found
Mary       —– File path/file name

Many thanks in advance,

Juan

​Dear all,I would be grateful if someone could provide me with the code for this problem, or point me in the right direction. I’ve tried a few codes but I haven’t managed to find a solution. I have a list of words in column A of Sheet 1. I would like to search for each of these words in multiple Excel files which are saved in one folder. If any of the words are found in any of the Excel files, I would like to know in which file it was found. In Sheet1 the result would look like this: Column A —- Column BPeter        —– File path/file nameJohn        —– Not foundMary       —– File path/file name Many thanks in advance,Juan  Read More

​