Sorry if the subject's a little cryptic, hehe. What I want to know is if its possible to use a named formula within a reference to an external file.
I created a few names that represent the file name, which stays constant except for the date. Its always in a "Filename_DDMMYY.xls" format. For example, "Report_140804.xls" would be the file for August 14, 2004. I know a reference to cell A2 in that file would be formatted as 'Report_140804.xls'!A2. So what I did was create the names:
fday - used the DAY function to pull the day from a cell
fmon - used the MONTH function to pull the month from a cell
fyr - used the RIGHT and YEAR functions to get the year in YY format
FDate - pulls it all together
Thing is, I get an error when I try to use it. I kind of figured it wouldn't work as "='Report_FDate.xls'!$L$2$L$30" or "='Report_&FDate&.xls'!$L$2$L$30". It tries looking for files named Report_FDate.xls. I'm just not sure how else it could be implemented. So, can this be done in any way?
Bookmarks