Is it possible to include within a formula a link to another file without specifying the file in question within the formula? ie: Can I have a formula in, say, cell B1 that will look at cell A1 to establish which file it needs to look at to find the required information.
EG: Cell A1 = February.xls
I need cell B1 to look at information contained in February.xls but next month A1 will change to March.xls and therefore update the information automatically (currently done manually, yawn)
The file was created by a colleague who doesn't want the file to change format so this is the easiest solution I can think of to update the formulae within the file without having to go into each cell and change each formula every month which is how it has been done so far. (PS: I know this colleague could simply use find and replace to change information but I'm not sure if he's thought of that yet!!!!)