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 |
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. |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com