Hello All,

I have a specific requirement which is as below.

Emp id Outcome Cumulative %
P1 1 logic ( 1/sum of coulumn outcome)*100
P2 2 logic ( 1+2/sum of coulumn outcome)*100
P3 6 Logic ( 6+1+2/sum of coulumn outcome)*100
P4 4 Logic(4+6+1+2/sum of coulumn outcome)*100
P5 5 Logic(5+4+6+1+2/sum of coulumn outcome)*100


The problem here is I cannot write direct formula because emp id and outcome is not fixed. It can grow up to any limit. So can any one tell me that how to fill the cumulative % coulmn by using a Excel VBA and stop the calcullation once the last value cell in emp id is recahed.

Many Thanks,
SP