Hi all,

This is probably a common problem but I've found no direct solution, so I'll bring it up again in case anything has been developed recently.

=> I need to search multiple Excel files, where the search criteria is applied to rows or cells, not the whole worksheet as if it were one giant cell.
Basically, a normal Ctrl+F type of search done across multiple files.

A solution would be especially great if it could handle multiple sheets in each file, but for now I'd be satisfied if it only did the active sheet in each file.

I'm open to a macro, a separate program/add-on, multi-step workarounds, etc....

... otherwise I'm considering converting every row (several hundred thousand) to a text file, where the filename is the content of:
  • the entire row, and the file is empty, or
  • one of the cells of the row, and the file content is the rest of the row

.... And then using a standard search tool to do a regular file search.

TIA for any suggestions!