I am having problems solving a seemingly complex issue with circular
referances.

Name wgt %
aaaa 100 0.25
bbbb 100 0.25
cccc 100 0.25
dddd 100 0.25

Total 400

The user inputs the weight and this works out the percent based of the
total.

Now say i want to add a new name called "eeee". But i want to specify
the % and it works out the weight.
I would have to refer the % to the toal weight which would change when
it works out the actual weight creating a circular referance.

Anyone got any ideas how to resolve this problem?


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=483073