simospavieri
New Member
- Joined
- Aug 26, 2011
- Messages
- 1
I wish to automatically set goal seek for several rows but with different values.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
And I wish to do so from cell A3 toA19 with changing values from B3 to B19, without manually introducing the value each time.<o></o>
<o> </o>
Ex:<o></o>
<o> </o>
GOAL Seek: set cell A3 to value =B3 by changing cell B3.
set cell A4 to value=A4 by changing cell B4
<o> </o>
etc…
And I wish to do so from cell A3 toA19 with changing values from B3 to B19, without manually introducing the value each time.<o></o>
<o> </o>
Ex:<o></o>
<o> </o>
GOAL Seek: set cell A3 to value =B3 by changing cell B3.
set cell A4 to value=A4 by changing cell B4
<o> </o>
etc…