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

P

PMAP_HELP

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
 
J

Jason Morin

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

=Book5.xls!myrange

HTH
Jason
Atlanta, GA
 
Top