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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Importing named range from another workbook 5
2007 to 2003 formatting troubleshooting 1
Changing linked worksheet and range of cells 7
automatically import multiple named-ranges from Excel to Access 1
delete multiple range names 8
Linking multiple ranges and worksheets to MS Word 1
Return multiple vales from a different spreadsheet into one cell 10
Delete Hidden Named Range 3

Back
Top