how do i reference data in a file with the fname in another cell?

[jhlrtn]

I am trying to get data from another excel file which the filename is input
in a cell on the current worksheet. For instance to do this manually for
each cell you type "=SUM('[ITD 03_25_05 ACTUALS.xls]PS-04B ITD Direct Actual
Cost'!$AD$34:$AD$35)". But I want to only put ITD 03_25_05 ACTUALS.xls in
one cell and refence this cell in the formula. What syntax/ functions must I
use and/or can this be done?

Thank you

 

[Danniel Chen]

try to use the following functions together:

Address - create a reference based on specified workbook name, sheet name,
row and col numbers;
Offset - create a range based on specified cell, # of rows/columns.


===== * ===== * =====
Daniel CHEN
(e-mail address removed)
www.Geocities.com/UDQServices
Download Free Data Processing Add-in
===== * ===== * =====