Can I automatically increase Named Ranges as I input data ?
Can I automatically increase Named Ranges as I input data ?
Hi
use a dynamic name such as
=OFFSET($A$1,0,0,COUNTA($A:$A))
--
Regards
Frank Kabel
Frankfurt, Germany
"Gerrym" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> Can I automatically increase Named Ranges as I input data ?
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.99999999999999E+307,Sheet1!$B:$B))
Gerrym wrote:
> Can I automatically increase Named Ranges as I input data ?
Frank, I originally set up the range by marking it and
then entering the name of the range in the NAME BOX. Them
I amended the range using the INSERT/NAME/DEFINE menus and
although the range name is here it has dissapeared from
the NAME BOX list and I get an error in the sheet that is
using the new range in calculation. Do you kno why this
is. Tks for help so far.
>-----Original Message-----
>Hi
>use a dynamic name such as
>=OFFSET($A$1,0,0,COUNTA($A:$A))
>
>--
>Regards
>Frank Kabel
>Frankfurt, Germany
>"Gerrym" <[email protected]> schrieb im
Newsbeitrag
>news:[email protected]...
>> Can I automatically increase Named Ranges as I input
data ?
>
>
>.
>
Frank, I sorted the error ok, I was including the column
name (Row 1) and the calc of amounts did not like this.
Still why do the named ranges now not show in the NAME BOX
list. ?
>-----Original Message-----
>Frank, I originally set up the range by marking it and
>then entering the name of the range in the NAME BOX. Them
>I amended the range using the INSERT/NAME/DEFINE menus
and
>although the range name is here it has dissapeared from
>the NAME BOX list and I get an error in the sheet that is
>using the new range in calculation. Do you kno why this
>is. Tks for help so far.
>
>
>>-----Original Message-----
>>Hi
>>use a dynamic name such as
>>=OFFSET($A$1,0,0,COUNTA($A:$A))
>>
>>--
>>Regards
>>Frank Kabel
>>Frankfurt, Germany
>>"Gerrym" <[email protected]> schrieb
im
>Newsbeitrag
>>news:[email protected]...
>>> Can I automatically increase Named Ranges as I input
>data ?
>>
>>
>>.
>>
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks