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 :


[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Amount[/TD]
[TD="class: xl63, width: 64"]Value[/TD]
[/TR]
[TR]
[TD="class: xl63"]1000[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]2000[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]15000[/TD]
[TD="class: xl63"]24000[/TD]
[/TR]
[TR]
[TD="class: xl63"]1000[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]2000[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]3000[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]24000[/TD]
[TD="class: xl63"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[My Aswer Is This]

Thanks a lot its working fine

Glad I was able to help you.