Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a formula
="'C:\Accounting\Files\[" &H5& ".xls]Sheet1'!$I$6"
Will return this in the cell. C:\Accounting\Files\[Accounting1.xls]Sheet1'!$I$6 But not the value of the cell I6 which is what I want. Thank you, Steven |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a formula
Think you need to use INDIRECT to resolve the link formula that you have
strung up, viz indicatively: =INDIRECT(<your concat string) But INDIRECT won't work on closed source files which is what your "link formula" suggests that you're trying to do. It'll work on open source files, or across sheets in the same book. For updating from closed source files, I'd just normal link formulas, and adjust these as necessary via EditReplace's. -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "Steven" wrote: ="'C:\Accounting\Files\[" &H5& ".xls]Sheet1'!$I$6" Will return this in the cell. C:\Accounting\Files\[Accounting1.xls]Sheet1'!$I$6 But not the value of the cell I6 which is what I want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate formula or & | Excel Discussion (Misc queries) | |||
help with formula...if -- concatenate | Excel Discussion (Misc queries) | |||
Concatenate in a formula | Excel Worksheet Functions | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
CONCATENATE formula | Excel Discussion (Misc queries) |