Cell reference to another file in Excel?

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!!!!)
danny moynes

Comments
There are 7 comments. Login or register to view them.

Neil Boyd, are you there?

AnonymousUser |

Isn't your change only one action anyway

ACDWebb |
ACDWebb's picture

External file cell reference - INDIRECT function

neilboyd |

More on INDIRECT - and a word of caution....

neilboyd |

I still think you will have a much easier & quicker task by chan

ACDWebb |
ACDWebb's picture

Indirect

neileg |

Back to front

neileg |