How to Link named ranges from multiple Workbooks into a single Wo.
 

I am trying to link named ranges together from multiple spreadsheets into a
single dynamic "Master" spreadsheet.
I can link cells but wasn't sure if I can link named ranges

Preced the name with a reference to the workbook. For
example:

=Book5.xls!myrange

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to link named ranges together from multiple
spreadsheets into a
single dynamic "Master" spreadsheet.
I can link cells but wasn't sure if I can link named
ranges
.