How to reference a cell in a external excel file based on a variable?
- by Totty
Hy I have a Excel File (a) and a cell into it that is equal to another cell in another file (b);
The of the (b) excel file is "2010 something";
Now The cell (c) is ='[2010 something.xls]test'!$K$224
What I want is to make a variable that mantains the year and will be stored into a cell
Then the cell (c) will change its reference based on the year; So in 2011 instead of looking for the 2010 something.xls will be looking for the 2011 something.xls
How to do it? thanks