make a quickjump

[zuapfly]

hi, i want to make a file that can calculate numbers from differen
excelfiles.

therefore i want to make a cell in this file in which you can enter th
name of an excel-file. Another cell where i can put the range for th
first variable in the excel-file, Another cell where i can put th
range for the other variable in the excel-file...etc...

please take a look at the simple dummyfile i put in attachment..

Attachment filename: results.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62348

 

[Don Guillett]

You can use the INDIRECT function, but NOT with closed files