One way,

Put in the formula bar for A1,
then array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER):

=INDEX(B:B,MAX(IF(ISBLANK(B1:B65535),0,ROW(B1:B655 35))))

The above was taken from Bob Phillip's fine page at:
http://www.xldynamic.com/source/xld.....html#last_any

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"YJL" wrote in message
...

I have a worksheet that keeps undating everyday. I want to track the
latest row's value and still keep the old one.

Example

A1 will always point to newly updated cell (B1, B2, B3 ... )

Day1, update on B1 <--A1 shows value of B1
Day2, update on B2 <--A1 shows value of B2
Day3, update on B3 <--A1 shows value of B3