Copying Value next to the highest value in column A

[kshitij_dch]

Hi ,

I was working on a sheet where i have some values in column A , in the last cell of column A is the SUM of the values.

I am looking for a code that will copy the sum of values next to the highest value in column A , for an example :

Amount	Value
1000
2000
15000	24000
1000
2000
3000
24000

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[My Aswer Is This]

Thanks a lot its working fine

Glad I was able to help you.