Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question relating to Named Ranges which exist in another workbook.
I am wondering if someone can answer the following question I have.
I have a workbook called Master Lookup which has one sheet called Master in it which has several columns. Each column is a named range (i.e. Establishment, Gender, Area€¦.). What I need to do is to reference any of the named ranges from another workbook, and I am firstly not sure whether Excel 2002 allows reference from 1 workbook to another. In most situations, workbook call Master Lookup will not be €˜open when other workbooks reference any of the named ranged. I am aware that if I want to use a named range as part of data validation that is in the same workbook, I would enter =sheetname through data validation in the appropriate cell, however if it is possible to reference another workbook, how would I enter the reference to that workbook. Additionally, as most of the named ranges will be variable in length I intend to have them set up using the OFFSET command. Any help offered would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question relating to Named Ranges which exist in another workbook.
This is a good question.
In a workbook called helper.xls we define a range A1:D8 and give it the Name zz In a different workbook we can enter: =SUM(helper.xls!zz) Just be sure that helper.xls is open so the reference cal be resolved the the second workbook. -- Gary's Student gsnu200703 "Pank" wrote: I am wondering if someone can answer the following question I have. I have a workbook called Master Lookup which has one sheet called Master in it which has several columns. Each column is a named range (i.e. Establishment, Gender, Area€¦.). What I need to do is to reference any of the named ranges from another workbook, and I am firstly not sure whether Excel 2002 allows reference from 1 workbook to another. In most situations, workbook call Master Lookup will not be €˜open when other workbooks reference any of the named ranged. I am aware that if I want to use a named range as part of data validation that is in the same workbook, I would enter =sheetname through data validation in the appropriate cell, however if it is possible to reference another workbook, how would I enter the reference to that workbook. Additionally, as most of the named ranges will be variable in length I intend to have them set up using the OFFSET command. Any help offered would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question relating to Named Ranges which exist in another workb
Gary,
Thanks for your input. I have subsequently found that Debra Dalgleish (http://www.contextures.on.ca/tiptech.html) has great examples relating to exactly what I want. I am in the process of trying out her step-by-step instructions to resolve my question. Once again thank U for your time, much appreciated. Pank "Gary''s Student" wrote: This is a good question. In a workbook called helper.xls we define a range A1:D8 and give it the Name zz In a different workbook we can enter: =SUM(helper.xls!zz) Just be sure that helper.xls is open so the reference cal be resolved the the second workbook. -- Gary's Student gsnu200703 "Pank" wrote: I am wondering if someone can answer the following question I have. I have a workbook called Master Lookup which has one sheet called Master in it which has several columns. Each column is a named range (i.e. Establishment, Gender, Area€¦.). What I need to do is to reference any of the named ranges from another workbook, and I am firstly not sure whether Excel 2002 allows reference from 1 workbook to another. In most situations, workbook call Master Lookup will not be €˜open when other workbooks reference any of the named ranged. I am aware that if I want to use a named range as part of data validation that is in the same workbook, I would enter =sheetname through data validation in the appropriate cell, however if it is possible to reference another workbook, how would I enter the reference to that workbook. Additionally, as most of the named ranges will be variable in length I intend to have them set up using the OFFSET command. Any help offered would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Query and expanding named ranges | Excel Discussion (Misc queries) | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named Ranges question | Excel Worksheet Functions |