: $$Excel-Macros$$ Automating a goal seek using an excel
formula
Dear Ankur,
Can you share a sample workbook with group.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL
ankur9_a
: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 21 June 2012 11:13 AM
Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Dear Ankur,
Please try it..
Sub Dynamic_Goalsheek()
Dim i As Long
Dim sh As Worksheet
Set sh
-macros@googlegroups.com
*Sent:* Thursday, 21 June 2012 11:13 AM
*Subject:* Re: $$Excel-Macros$$ Automating a goal seek using an excel
formula
Dear Ankur,
Please try it..
*Sub Dynamic_Goalsheek()
Dim i As Long
Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets(1)
For i = 2 To sh.Cells
@googlegroups.com
Sent: Thursday, 21 June 2012 11:13 AM
Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Dear Ankur,
Please try it..
Sub Dynamic_Goalsheek()
Dim i As Long
Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets(1)
For i = 2 To sh.Cells(Rows.Count, A).End(xlUp
AGGARWAL
Sent: 21 June 2012 2:52
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Let me redefine the problem,
We are getting NPV values from some data base. Based on NPV value, we have
to automate a process which will back calculate
Center
Mckinsey Co.
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 21 June 2012 5:55 PM
Subject: RE: $$Excel-Macros$$ Automating a goal seek using an excel formula
I think it can be done by enabling iteration
-Macros$$ Automating a goal seek using an excel formula
Hi Rajan,
formula is in B6, B5 is the set value, we need to predict B4.
We will get the refreshed value in cell B5. ( Means this value is coming again
and again fro the DB ).
Please let me know if iteration will help. ?
Warm Regards
Experts, is it at all possible to automate goal seek function using an excel
formula without a macro. Set value in goal seek function will get refreshed
every day, we don't want to manually apply goal seek each time neither wanna
use the macro to automate that.
Can it be done using any
Dear Ankur,
Please try it..
*Sub Dynamic_Goalsheek()
Dim i As Long
Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets(1)
For i = 2 To sh.Cells(Rows.Count, A).End(xlUp).Row
sh.Range(I i).GoalSeek Goal:=sh.Range(A i).Value,
ChangingCell:=sh.Range(E i)
Next i
End Sub
*
See attached sheet hope it