up vote 1 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
25% accept rate
feedback

1 Answer

up vote 0 down vote

If your 2011 value is stored in cell A1, then, in some other cell, you could try this formula: ="'[" & A1 & " something.xls]test'!$K$224"

link|improve this answer
1  
this just makes a string.. i dont get the referenced value – Totty Mar 2 '11 at 17:07
Just found it: use INDIRECT function/method – Totty Mar 2 '11 at 17:26
yeah...sorry; I meant to include the INDIRECT idea ! (No, really!) – F106dart Mar 2 '11 at 17:55
still so not solves my problem because I need this to work even if the worksheet is closed – Totty Mar 3 '11 at 9:43
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.