I have around 160 excel files with between 20-60 thousand rows of data in each of them.
What I am wanting to do is search all 160 files for a specific word...I really don't care where it is inside the file as long as I can get a total of how many times it shows up in each file.
I really just need a total count of how many times the word shows up or an outputed list would be better.
Any way this can be done?
pmw
Bookmarks