Hi
if you don't have blank rows in between you may try the
following formula in A1
=OFFSET($B$1,COUNTA(B:B)-1,0)

-----Original Message-----
I want to assign the value of A1 = the last cell of col B
which is changing
when a new entry is added.
How can I do it but writing simple programme.


.