Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can references to cells be used as part of a workbook reference | Excel Discussion (Misc queries) | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Named ranges: don't want absolute references | Excel Discussion (Misc queries) | |||
Named ranges: don't want absolute references | Excel Discussion (Misc queries) | |||
Using a formula to create named range reference | Excel Worksheet Functions |