Adjust Percent

do you mean to populate columns C, D and E using Excel formula?

can you provide logic to calculate the percentage in column C?

Ryan Chong

Thanks for the fast reponse

what i mean is  coumn E is the portion of column D

sets is the percent od total columns
thats the correction needed


rigth now is num percent of count  that wrong

the corrected formula in the code should be

example row 4   ==   sets 8 / total columns 10 * 100 = 80%

that the correction needed in the code

because 8 sets of 10 toral columns  * 100 = 80% for row 4 like example

btw, for column C, i just format it instead of multiple it by 100. hence, you can do necessary amendment when necessary.

Great JOB !
Great Expert !

Ryan Chong

column D  and column E

have the data i alredy need that comes from   V_OUT


but column C is computing alredy % from  column A /B

but whats  I Need is column  E/D

but need that in the code because the code have the worng formula (A/B)

but whats  I Need is column  E/D

but need that in the code because the code have the worng formula (A/B)

you probably can't save "memory" in the Excel file, so you got to: create another column for the correct percentage formula in case you want to remain the wrong formula in column C (A/B)

Ryan Chong

formula (A/B ) is not needed

Ryan Chong

where in the code can be fixed

E/D is the corrected needed

this the file need the correction
65434677665v1--2-_43532.xlsm

E/D is the corrected needed

isn't that in the sample file I uploaded contain the correct formula?

Ryan Chong

you rigth great expert