Hi
then Excel is probably not the right tool for this task

--
Regards
Frank Kabel
Frankfurt, Germany

"Jeff Farrar" schrieb im Newsbeitrag
news:dVPhd.560814$8_6.191449@attbi_s04...
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