Dynamic range where the reference cell can change

  • Thread starter Thread starter hello
  • Start date Start date
H

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
 
How (just entered or row inserted) and where (before row 57 or after) is the
new data entered.
 
Back
Top