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!

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!

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!

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 -