That's fine in a one time solution. What I am trying to do is have a list
of inputs on "Sheet 1" and have the results calculated on the other 50 or so
sheets. I need to put in the values and have it produce the results
automatically. There are a ton of areas where I would need to use this
feature. I need this to be automated.

Thanks.



"Alex Delamain" wrote in
message ...

the new "improved" method is Tools, Goal Seek

A1=0.0313
B1=your formula
C1= your reference / target value
D1=b1-c1

Then tools, Goal Seek
Set Cell: D1
to Value: 0
By changing cell: A1

This should then iterate through until it finds a solution


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile:
http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274556