Cross linked cells to distrubute percentage
 

We experienced problem to make model for following calculations.
The are 5 groups of values, together making 100%
Lets say:
10 20 30 35 5 all together 100%.
We would like to increse or decrese one value, and other values should
automatically increase or decrease by same value, making together
constant 100%
We need to put sliders for each sell, so you could move one, all other
moves automatically.

Thanks for help.


--
rihardsg
------------------------------------------------------------------------
rihardsg's Profile: http://www.excelforum.com/member.php...o&userid=35937
View this thread: http://www.excelforum.com/showthread...hreadid=557283