One way ..

Put in A1's formula bar, then array-enter the formula
(press CTRL+SHIFT+ENTER):

=INDEX($B1:$IV1,MATCH(TRUE,$B1:$IV1="",0)-1)

Copy A1 down as required to return correspondingly
for rows2, 3, ...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rashid" wrote in message
...
Suppose A1 is my final value cell, and B1 - M1 are values for each month
from
Jan -Dec. When I input something in B1 (Jan), it should show up in A1,
then
if I input something in C1 (Feb), it deletes the value in A1 and updates
it
with the value in C1 and so on. Thanks.