Dynamic range where the reference cell can change

[hello]

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

 

[Don Guillett]

How (just entered or row inserted) and where (before row 57 or after) is the
new data entered.

 

[hello]

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