last update value

[Sam.K]

Hi, my excel workseet have 12 column of column a,b,c,d,e,f,g,h,i,j,k,l. but when i input the value to each column ,only the last value will show up in the cell p3 how can i do..eg,
if the last cell input in column g1=615 the cell p3 will be=615
if the last cell input in column k1=850 the cell p3 will be=850
if the last cell input in column L1 =890 the cell p3 will be=890
Please see the attach file ,thank

[Andy Pope]

You would use the Change event to capture changes in the range A1 to L1 and copy the change to P3.

Right click sheet tab and pick View Code.
Paste the following.

Please Login or Register  to view this content.

[Sam.K]

hi, thank for your reply
your solution is not my concept, when i delete the L1 value cell p3 must be=cell k1 in which will be =850 not be the blank cell.
can any way to cell the code.

and have another way to do by the function code not vba.

[Andy Pope]

This will return last value in range, as long as all cells to left are filled.

=INDEX(A1:L1,1,COUNT(A1:L1))

[Sam.K]

Hi, thank your last code is my concept . it is very best.
but please help me some more that in the case of ...
when my 12 column cell value is in cell h1,l1,p1,t1,x1,ab1,af1,aj1,an1,ar1,av1 and az1
how can i change your last code to get the result.
thank.
please see the attach file

[Andy Pope]

Try this,

=INDEX(E1:AZ1,1,COUNT(H1:AZ1)*4)

In future please post your actual question rather than revealing bits of information as you go.

[Sam.K]

Thank, andy

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save