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