The syntax looks like this, where Volsheet is the name in the other
workbook:
lFormula in this workbook referring to Global Name in External book
-Names2.xls!Volsheet
lFormula in this workbook referring to Local Name in External book
-[Names2.xls]Sheet2!Volsheet
regards
Charles
__________________________________________________
The Excel Calculation Site http://www.decisionmodels.com
With both files open: on the required sheet of file 1 type =, then click on
the named cell in file 2.
This results in a formula like ='Annual data 2008.xls'!mydata
best wishes
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
