return last value of a sheet
=LOOKUP(2,1/($A$1:$A$65535<0),$A$1:$A$65535)
if there can be no blank cells between last and first value you might use
=INDEX(A:A,COUNTA(A:A))
--
Regards,
Peo Sjoblom
"widman" wrote in message
...
Is there a formula I can put on a worksheet that picks up the values from
the
last row entered in the previous sheet, changing as rows are added.
In other words, this forumla in A1 of sheet 2 would show the value of A20
in
sheet 1 until values were put into A21, then they would show the values
from
A21, then A22, etc.
|