Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically increase Named Ranges
Can I automatically increase Named Ranges as I input data ?
|
#2
|
|||
|
|||
Hi
use a dynamic name such as =OFFSET($A$1,0,0,COUNTA($A:$A)) -- Regards Frank Kabel Frankfurt, Germany "Gerrym" schrieb im Newsbeitrag ... Can I automatically increase Named Ranges as I input data ? |
#3
|
|||
|
|||
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 ? |
#4
|
|||
|
|||
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" schrieb im Newsbeitrag ... Can I automatically increase Named Ranges as I input data ? . |
#5
|
|||
|
|||
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" schrieb im Newsbeitrag ... Can I automatically increase Named Ranges as I input data ? . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
Named Cell Ranges | Excel Discussion (Misc queries) | |||
Viewing List of Named Ranges | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |