Two possible approaches, depending on your abilities and specific
needs:
1) VBA code associated with a worksheet_change or calculate event that
calls solver for you
2) If you are familiar with programming numerical methods, you could
code a UDF that will use a Newton-Raphson algorithm (or other numerical
algorithm) to solve the problem. UDF would then be called from C1 of
the spreadsheet, and, if coded correctly, will fit into the dependency
tree and will update automatically as values change.


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