Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File reference
I am trying to reference data in an external workbook and would like to save
some typing. Each row has the same references, but to a different file. I would like to just type the file name in the first cell and have each of the following cells use that cell to get the file name and perform the function. For instance: ='[external_file.xls]Enterprise Architecture'!$B$3 But the formula would contain some function that would get external_file.xls from the first cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
Reference a cell on another worksheet in the same spreadsheet file | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Automatically change tab reference | Excel Discussion (Misc queries) |