| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference to an external file
If I want to copy one cell from another file I will do
=[FileName.xls]SheetName!$I$10 But if I want the file to vary depending on a cell A1 value... I mean If cell A1 value is equal to Q1 then file name will be [Q1 FileName.xls] If cell A1 value is equal to Q2 then file name will be [Q2 FileName.xls] How do I make a formula so the file name depend on the cell value I tried [A1&" FileName.xls"]SheetName!$I$10 but did not work.... How can I do it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate path and file string for external reference | Excel Worksheet Functions | |||
| how to call a reference to a cell in external file | Excel Worksheet Functions | |||
| external reference to file in the same folder | Excel Discussion (Misc queries) | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
| External Reference | Excel Discussion (Misc queries) | |||
![Alberto Ast[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
