| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting of Data from .CSV file | Excel Worksheet Functions | |||
| Dowloading internet data to worksheet form a ".ccv" file | Excel Worksheet Functions | |||
| Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
| Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
