I have an unusual question I am really hoping you can all help me out.
I have a "Master Spreadsheet" that references to multiple other spreadsheets and their specific cells. This is done by inputing the directory and the referencing cell (e.g A1) into the master spreadsheets cell.
Hi I have the Macro below that will search throught a directory and list the .Xls in it. What I am now trying to do with this is to create a hyperlink from the results that will take me right to the spreadsheet?
Is there anything i can easily put in Thanks to anyone that can help :)