Dear Excel friends,

I have probably a simple Question.
In Cell A1,A2,A3 i can enter percentages. The summation of those cells always equals to 100%.

E.g. By entering A2 (20%) and A3 (30%) vba should fill cell A1 automatically with 50%.
E.g. By entering A1 (35%) and A3 (35%) vba should fill cell A2 automatically with 30%.
....................

Can somebody help me?

with kind regards,

Marc