How to edit the link?
 

='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but
I would like to retrieve the value 6227 from cell B1 for this statement
instead of manually input the value 6227 into the string.
Do you have any suggestion?
Thank you for any suggestion
Eric

How to edit the link?
 

you need to build your name with the indirect() function,which accepts text
strings and converts them to a reference.Any other workbook MUST be open
--
paul

remove nospam for email addy!



"Eric" wrote:

='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but
I would like to retrieve the value 6227 from cell B1 for this statement
instead of manually input the value 6227 into the string.
Do you have any suggestion?
Thank you for any suggestion
Eric