Is it possible to use data from different workbooks in formulas?
 

Is it possible to use data from one workbook (a master listing of restaurants
and managers) when creating formulas in different workbooks? What I would
like to do is when I am creating new workbooks for various reports, I would
like to be able to create a forumla to populate the restaurant and managers
column in the new workbooks with the information from the master listing
workbook. Is that possible?

Thanks for you help
Steven Edmonds

in file2.xls, use:

=[FILE1.xls]Sheet1!$A$1




"guyinrenton" schreef in bericht
...
Is it possible to use data from one workbook (a master listing of
restaurants
and managers) when creating formulas in different workbooks? What I would
like to do is when I am creating new workbooks for various reports, I
would
like to be able to create a forumla to populate the restaurant and
managers
column in the new workbooks with the information from the master listing
workbook. Is that possible?

Thanks for you help
Steven Edmonds