Hey all im willing to learn whatever just point me in the right direction :-)

What im needing to do is search a specific directory full of .XLS files and return hyperlink(s) to all files that contain the Search String... Example

Column A1 - A100 has search words
Column B1 - B100 Returns a Hyperlink(s) to all files within directory that contain that word.

I saw some Marcos on here that will search but how would you get the marco to output to a specific Cell?

Any questions or anything i left out that you need let me know thanks alot!