Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Trim down on cell references
Hi,
I have a formula that is quite long, and is made a lot longer because it refers to cells in another workbook, so that the names of the workbook and worksheet are repeated for each cell reference to the workbook. Is there any way to tackle this issue? |
#2
|
|||
|
|||
With the other workbook named, say, Book1.xls, open, in your target
workbook choose Insert/Name/Define and enter a name for the range in Book1. For instance Names in workbook: rng Refers to: '[Book1.xls]Sheet1'!$A$1:$A$10 Then use the name instead of the direct reference: =SUM(rng) In article , "robot" wrote: Hi, I have a formula that is quite long, and is made a lot longer because it refers to cells in another workbook, so that the names of the workbook and worksheet are repeated for each cell reference to the workbook. Is there any way to tackle this issue? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
Fixed cell references | Excel Discussion (Misc queries) | |||
How to use complex no. functions that have cell references? | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) |