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? |
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) |