Hi guys,
I have a spreadsheet that needs to get data off another spreadsheet but the problem is a new report comes out daily with the same prefix filename everyday but the only thing that changed in the filename is the date in the end.
ex: SignOn-Agents-UTOPIA - 2012-04-18 - Mercredi1.xlsx
How can I pull up the data depending on the date i put in a specific cell?
Bookmarks