Hello,
Sub goalSeekSample()
Dim seekValue As Double
Dim changeCell As Range
seekValue = InputBox(“What’s the value to seek?”)
For Each changeCell In Range(“N14:N32”).Cells
changeCell.GoalSeek Goal:=seekValue, _
ChangingCell:=changeCell.Offset(0, -4)
Next changeCell
End Sub
This macro opens a box, i type a number and it goes down the software using goal seek to adjust column J to achieve that number in column N on each row.
it works fine.
but instead of inputing the number, i would like it to look at the cell to the right (column “O” ) and use that number.
this will increase the net amount by the multiplier ‘inflation’
note recording the number wont work cos goal seek wont accepet cell addresses.
thanks all
http://www.4shared.com/file/84814527/8298b493/Copy_of_RRIF_2?009.html
this is the excel file
