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 |
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 www.Geocities.com/UDQServices Download Free Data Processing Add-in ===== * ===== * ===== "jhlrtn" wrote: 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 |
All times are GMT +1. The time now is 07:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com