Link value from another excel file, using filename in a cell
Posted by Erik Niemi on May 29, 2001 6:34 AM
Hello!
I want to link a cell value from another excel file and use a value in a cell to tell what file i want to get the value from.
The normal way to link a value can look like this =[testfile.xls]sheet1!$a$1
But i wonder if there are any way to replace the file name and use a cell reference instead?
My problem is that i want to link values from many different files and i want a number in a specifik cell to tell from what file it should get the data.