Conditon based calculation in excel using VB script/Macro

[Sree1]

Hello All,

Please help me with this.
I have a specific requirement which is as below.
There are three columns in excel. Employee No, Sales count and Cumulative %.

[Employee No.] [Sales count] [ Cumulative %]
[ 1 ] [ 10 ] [Logic : (10/sum of coulumn Sales count)*100 ]
[ 2 ] [ 9 ] [Logic : ((10+9)/sum of column sales count)*100]
[ 3 ] [ 6 ] [Logic : ((6+9+10)/sum of coulumn sales count)*100]
[ 4 ] [ 4 ] [Logic : ((4+6+9+10)/sum of coulumn sales count)*100]
[ 5 ] [ 5 ] [Logic : ((5+4+6+9+10)/sum of coulumn sales count)*100]
[ . ] [ . ] [ . ]
[ . ] [ . ] [... ]
[ . ] [ . ] [ ............... ]
I want to calculate values for cumulative %. The logic is the one given in above sample data. Please have a look at the attachmnet if data given above is not clear.
The problem here is I cannot write direct formula because Employee No. and sales count 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 VB script and stop the calcullation once it is done for all Employee numbers present in first coulmn.
Many Thanks,
Sreeja

[FDibbins]

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)