Fill A cell with the last entered value in the column.

[hsshah]

-- removed inline image ---


I have to enter the next value in column D to the cell D1
e.g. if the next value entered is 1000 in D4 then the value in cell D1 should be 1000
again if the next value entered is 23 in D5 then the value in cell D1 should be 23
Thanks in advance for anyone that helps

 

[VoG]

Try

=LOOKUP(9.9E+307,D2:D1000)

 

[hsshah]

Thanks man for the help
Thanks a lot