I
Ivor Davies
Probably a stupid question.
I can dynamically name a columular data range using the Insert>Name>Define
=OFFSET(Sheet!$A$1,0,0,COUNTA(Sheet!$A:$A) function. This allows me to add
data to a list and the named range automatically takes the new data into
account, very handy indeed.
Problem is I need to apply the same dynamic range to a table of data, not
just a single column, so it needs to recognise new data in the rows below and
to columns to the right of the named range.
I tried changing the COUNTA(Sheet$A:A) part of the formula to take the other
columns of data into account (I.e. COUNTA(Sheet$A:ZZ) but it doesn't
recognise this as a valid range.
Any idea how to do this?
I can dynamically name a columular data range using the Insert>Name>Define
=OFFSET(Sheet!$A$1,0,0,COUNTA(Sheet!$A:$A) function. This allows me to add
data to a list and the named range automatically takes the new data into
account, very handy indeed.
Problem is I need to apply the same dynamic range to a table of data, not
just a single column, so it needs to recognise new data in the rows below and
to columns to the right of the named range.
I tried changing the COUNTA(Sheet$A:A) part of the formula to take the other
columns of data into account (I.e. COUNTA(Sheet$A:ZZ) but it doesn't
recognise this as a valid range.
Any idea how to do this?