My approach to this kind of problem is to use Solver/Goal seek. Set up
spreadsheet like you have, add the row, put a number in for wgt of eeee
and the formula to calculate its wgt%, then run Solver, set target cell
(wgt% eeee) to value of x%, by changing the appropriate wgt of eeee
cell, and let Solver solve the problem.


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