Inserting a variable over a formula

[gogobruno]

http://img199.imageshack.us/img199/7299/imagemlek.jpg

Hi guys!

Looking the picture may help out what i want to do, is quite simple i have that "=[HHH2222.xlsx]Sheet1!$C$4" , and i want to make the part with the file name "HHH2222" came from a cell like "A4", so that i can change A4 and everything else may change along.

Thanks!

[NBVC]

To do that you need to download and install and Addin from here: Morefunc.xll

and use formula:

=INDIRECT.EXT("'["&A4&".xlsx]Sheet1'!$C$4")

[gogobruno]

I will try that, thank you very much!

[gogobruno]

To do that you need to download and install and Addin from here: Morefunc.xll

and use formula:

=INDIRECT.EXT("'["&A4&".xlsx]Sheet1'!$C$4")

It worked but just if my sheet is open, i need it to refresh the value without the sheet being open because i need to be able to see the values without having to open all the sheets that i use.



Please further answer me, thanks!

[NBVC]

You will need to include the full path...

e.g..


=INDIRECT.EXT("'C:\Mydocs\ExcelDocs\["&A4&".xlsx]Sheet1'!$C$4")

[gogobruno]

You will need to include the full path...

e.g..


=INDIRECT.EXT("'C:\Mydocs\ExcelDocs\["&A4&".xlsx]Sheet1'!$C$4")

Thank you man! saved my life, literally, haha, in debt. bruno.