ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i reference data in a file with the fname in another cell? (https://www.excelbanter.com/excel-worksheet-functions/27401-how-do-i-reference-data-file-fname-another-cell.html)

jhlrtn May 23rd 05 08:28 PM

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

Danniel Chen May 23rd 05 11:11 PM

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:16 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com