Concatenate a reference to named ranges in other workbook
Hi, I hope you can help....
If I go through the long process and select
='C:\Documents and Settings\me\My Documents\BNS\BNS20060002.xls'!Invoice_date
it will return the value of the cell
but....
when B11= 'C:\Documents and Settings\me\My Documents\BNS\
when A27= BNS20060002
When B20= Invoice_date
I write
=CONCATENATE(B11,A27,"xls'!",B20)
It creates
='C:\Documents and Settings\me\My Documents\BNS\BNS20060002.xls'!Invoice_date
seemingly as text, how do I get it to be a cell reference?
I need to build this reference automatically.
|