Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to dynamically reference a dynamic named range
I did a search, but came up empty. Assume I have a dynamic named range called "RANGE" that starts at A1. As I add to A2, A3, the named range increases. That's the easy part. Now I want to have cells elsewhere on the sheet refer to the contents of the named range. Say I want to have L1 display A1, L2 display A2, etc. In effect, I want the L column to mirror A. How can I get this to happen dynamically, so that if I have three items in RANGE, then the new cell range is three cells tall, etc.... and if I add to column A, it automatically is reflected in column L. I suspect I have to use OFFSET with the named range, but I'm lost as to how to apply that logic. Thanks in advance. -- paris3 ------------------------------------------------------------------------ paris3's Profile: http://www.excelforum.com/member.php...fo&userid=3542 View this thread: http://www.excelforum.com/showthread...hreadid=381412 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference to a dynamic range | Excel Discussion (Misc queries) | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
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 |