How to create a dynamic named range?

S

Sunita

Hi there,
Would like to create a named range that increased when I added rows - please
assist!!
Look forward to any help.

Merci!
 
V

vezerid

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
 
Top