Hi,
I have a workbook that uses a few formulas to get data from another workbook. Since the name of the workbook that the main spreadsheet feeds off changes every month, I want to put a reference to a cell in the formula so that I can get the formulas to refer to the new file name:
This is one of the formulas I'm using:
='G:\Risk Management\DailyReports\ABS\090929\[29-September-09.xls]intex data analysis'!FB12
And I would like to be able to change this part of the formula: 090929\[29-September-09.xls] to being a reference to another cell (or cells) but when I put a cell reference in the formula it doesn't seem to work.
Is there a way to do this?
Many thanks,
Luca
Bookmarks