G
Guest
Guest
Im putting together a summary excel file that pulls information from various other excel files that coworkers are continuosly updating. The file naming system we have here is to put the date of the update in the actual file name. So an update done today would would require the file name to be 022802Income.xls for example. Right now, I just have the links referencing to this file, and go to 'edit links' to update the source files as necessary. Is there a way to have the reference check the modified date of all the files in the directory with the word "income" in the file name (keeping my example), and pull from the one that is most recent? Thanks in advance.
