Hi.
I have few numbers that sum up to 100 (percentage) in excel spreadsheet. When a user changed one of the numbers the sum was changed too, obviously. Lets call this sum value "S". I need a macro to change the values of the rest of the nubers (proportionally) in order that the sum "S" will be 100 again.
To do that, each one of the values needs to be divided by "S" and multiply by 100. I wrote following macro code for excel. It "almost" working: I need to divide each number by the intial sum"S" but it dividing each number by the most updated Sum each time.
Please help me to correct this macro. Thanks!
Bookmarks