In excel i want to compare particular cells and take the highest value and place in parent cell when particular cells update : [enter image description here][1]


  [1]: http://i.stack.imgur.com/Bfv6L.png

1)  Hi in the above image A column is having sum values help me with any formula    so  that in A13 i need an updated highest value.

2) Guys please help me i am running automated sequences so first it will update A12  with 90 then 90 should updated in A13 next again may A9 updates with 101 value so that A9 value should update in A13 so it should lookup in the latest cell and updated the value and should reflects in  A13 cell help me even if it is macro but also be noticed i am running automated sequences i can't run macro manually so help me with code that runs automatically based on an cell input


thanks in advance.

