Hi,
Sorry about the wording of the title, I don't know how best to word this.
I have a large number of Excel spreadsheets in subfolders that I wish to obtain information from. Currently, I need to type in the path and filename into each cell. There is a spreadsheet for every single day, and...