Dynamic range where the reference cell can change
 

Hello

I am trying to make a dynamic range using the OFFSET function, but where the
reference cell of this range can change. The following formula works well as
long as the reference cell is fixed at test$A$57

=OFFSET('test'!$A$57,1,0,COUNTA('test'!$A:$A)-6

However, as the data are updated, I want the range to start at A58, A59,etc.
If anyone can help I would be most grateful.

Thank you very much

Dynamic range where the reference cell can change
 

How (just entered or row inserted) and where (before row 57 or after) is the
new data entered.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"hello" wrote in message
...
Hello

I am trying to make a dynamic range using the OFFSET function, but where
the
reference cell of this range can change. The following formula works well
as
long as the reference cell is fixed at test$A$57

=OFFSET('test'!$A$57,1,0,COUNTA('test'!$A:$A)-6

However, as the data are updated, I want the range to start at A58,
A59,etc.
If anyone can help I would be most grateful.

Thank you very much

Dynamic range where the reference cell can change
 

Thanks for the reply. The data will be just entered, after row 57.

"Don Guillett" wrote:


How (just entered or row inserted) and where (before row 57 or after) is the
new data entered.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"hello" wrote in message
...
Hello

I am trying to make a dynamic range using the OFFSET function, but where
the
reference cell of this range can change. The following formula works well
as
long as the reference cell is fixed at test$A$57

=OFFSET('test'!$A$57,1,0,COUNTA('test'!$A:$A)-6

However, as the data are updated, I want the range to start at A58,
A59,etc.
If anyone can help I would be most grateful.

Thank you very much