Lets suppose that the area of interest is in A:C on Sheet1, with labels
in A1:C1, and column B is of numeric type (numbers, hours, or dates) and
the area crimps or expands only in vertical direction...

Define Drange (of Data Range) as referring to:

=Sheet1!$A$2:INDEX(Sheet1!$C:$C,MATCH(9.9999999999 9999E+307,Sheet1!$B:$B))

Gerrym wrote:
Can I automatically increase Named Ranges as I input data ?