Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you point to a named range in linked workbooks?
Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I
point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2? |
#2
|
|||
|
|||
Is this what you're looking for...?
In workbook 2 enter "=[Book1]Sheet1!$A$2" in cell A2. Do the same for cells B2 through K2 with the correct respective links. Hope this helps. -Chad "KG" wrote: Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2? |
#3
|
|||
|
|||
Or, if you don't like to type, try it this way:
Open both files with Workbook #2 active, click cell A2 & type = Go to WindowWorkbook #1 (or click the taskbar button), click cell A2 & press Ctrl+Enter (this finishes your formula & leaves A2 as your active cell). Use the Fill Handle to copy right or down (one direction at a time), then fill in the other direction. Suggestion- read up on "Links to other Workbooks" because there are a number of considerations to know about. Hope this is useful |:) "KG" wrote: Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2? |
#4
|
|||
|
|||
KG,
'Book 1.xls'!GrossSales For example: =SUM('Book 1.xls'!GrossSales) =VLOOKUP(A2, 'Book 1.xls'!GrossSales, 2) Note that a Range name cannot have a space, hence GrossSales, not Gross Sales. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "KG" wrote in message ... Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2? |
#5
|
|||
|
|||
Thanks for the catch; actually my named range is Gross_Sales. I'm intrigued
by the VLOOKUP method. I know that in regular VLOOKUP tables the third parameter (2 in your example) designates the column where Excel starts its lookup. What does it do in the case of a named range? "Earl Kiosterud" wrote: KG, 'Book 1.xls'!GrossSales For example: =SUM('Book 1.xls'!GrossSales) =VLOOKUP(A2, 'Book 1.xls'!GrossSales, 2) Note that a Range name cannot have a space, hence GrossSales, not Gross Sales. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "KG" wrote in message ... Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2? |
#6
|
|||
|
|||
KG,
It's the same as any VLOOKUP. The third parameter, 2, is the column of the table from which to return something. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "KG" wrote in message ... Thanks for the catch; actually my named range is Gross_Sales. I'm intrigued by the VLOOKUP method. I know that in regular VLOOKUP tables the third parameter (2 in your example) designates the column where Excel starts its lookup. What does it do in the case of a named range? "Earl Kiosterud" wrote: KG, 'Book 1.xls'!GrossSales For example: =SUM('Book 1.xls'!GrossSales) =VLOOKUP(A2, 'Book 1.xls'!GrossSales, 2) Note that a Range name cannot have a space, hence GrossSales, not Gross Sales. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "KG" wrote in message ... Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ClearContents method on a passed range | New Users to Excel | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Address of named range | Excel Worksheet Functions | |||
Single quotes in named range | Excel Worksheet Functions |