I have a directory with a large number of excel workbooks. I'd like to
be able to search each workbook and extract a complete row if that row
contains the search term I'm looking for. Ideally the row extracted
would be placed into a new worksheet along with the name of the file
that row came from. The unix grep command is the fucntionality I'd
like to emulate. Is there a way to do that with a macro or are there
other tools I could use on a PC to accomplish my goal?


John Keith