I created a drop down list. The list contains the names for certain Excel
files without the extension ".xls" (File1, File1, File3, etc). Those files
are stored in the same directory.
In a different field I want to select data from one of the drop down list
files. In that box I put: " ='B3.xls'!data "
B3 is the location of the drop down list to select the specific file; data
is the cell name in the data file.
Needless to say that this doesn't work, but I hope someone knows how I can
do this differently without using the huge IF-statement that I am using now.
Thanks!