Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a dynamic named range?
Hi there,
Would like to create a named range that increased when I added rows - please assist!! Look forward to any help. Merci! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a dynamic named range?
Say your data start from 'Sheet1'!A5 and rows are added below. The
following dynamic range will be correct if you do not have any other above A5: =OFFSET('Sheet1'!$A$5,0,0,COUNTA('Sheet1'!$A:$A),) Insert|Name|Define... Enter the name for your dynamic range and then, in Refers to: enter the above formula or its modification. HTH Kostis Vezerides On Mar 28, 4:30*pm, Sunita wrote: Hi there, Would like to create a named range that increased when I added rows - please assist!! Look forward to any help. Merci! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a dynamic named range?
Hello Kostis,
Your prompt response is much appreciated!! Thanks "vezerid" wrote: Say your data start from 'Sheet1'!A5 and rows are added below. The following dynamic range will be correct if you do not have any other above A5: =OFFSET('Sheet1'!$A$5,0,0,COUNTA('Sheet1'!$A:$A),) Insert|Name|Define... Enter the name for your dynamic range and then, in Refers to: enter the above formula or its modification. HTH Kostis Vezerides On Mar 28, 4:30 pm, Sunita wrote: Hi there, Would like to create a named range that increased when I added rows - please assist!! Look forward to any help. Merci! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a dynamic named range?
Glad to be of help!
Regards On Mar 28, 5:15*pm, Sunita wrote: Hello Kostis, Your prompt response is much appreciated!! Thanks "vezerid" wrote: Say your data start from 'Sheet1'!A5 and rows are added below. The following dynamic range will be correct if you do not have any other above A5: =OFFSET('Sheet1'!$A$5,0,0,COUNTA('Sheet1'!$A:$A),) Insert|Name|Define... Enter the name for your dynamic range and then, in Refers to: enter the above formula or its modification. HTH Kostis Vezerides On Mar 28, 4:30 pm, Sunita wrote: Hi there, Would like to create a named range that increased when I added rows - please assist!! Look forward to any help. Merci!- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a dynamic named range | Excel Discussion (Misc queries) | |||
Dynamic Named Range | Excel Discussion (Misc queries) | |||
Dynamic Non Consecutive Named Range? | Excel Worksheet Functions | |||
#value! error trying to create a simple dynamic named range | Excel Discussion (Misc queries) | |||
Dynamic Named Range | Charts and Charting in Excel |