View Single Post
  #1   Report Post  
Old May 23rd 05, 08:28 PM
Posts: n/a
Default how do i reference data in a file with the fname in another cell?

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