| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Referring To A Cell In A Workbook Name Based On A Cell Value
I am writing a formula in cell "C1" in "Workbook #1" that will reference cell "D76" in a workbook that has not been created yet. The way I will tell the formula what the name of the workbook will be is by referencing cell "A1" and adding the extension .xls to it.
Example: "Workbook #1" _A___|B_|C 1_Tax_|__|=c:workbooks\A1.xls, spreadsheet1, cell # D76 (c:workbooks\Tax.xls, spreadsheet1 cell # D76) 2_____|__|__ Can anyone tell me the formula syntax to accomplish this, or is it even possible? Thank you for any replies, -Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to first cell in a range | Excel Discussion (Misc queries) | |||
| HYPERLINK() referring value from a cell does not change when cell | Excel Worksheet Functions | |||
| Sum values referring to a cell with same value | Excel Discussion (Misc queries) | |||
| referring to a cell containing a file name | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Threaded Mode
