$$Excel-Macros$$ Goal seek tool base on changing to value

Dear All, I have attached 2 files, one PNG for your quick reference and one is xlsx file. I need a macro to check if J coloumn is blank or empty then macro should stop. Coloum I is set cell (c_calculated) column J is to value (c_actual) which is always changing as per row column D id by

$$Excel-Macros$$ Goal Seek in Excel

Hi Friends, Feels worth sharing this to you. How to use Goal Seak in Excel https://youtu.be/X-MnANROaiQ Thanks & Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ GOAL SEEK

Sir, You are superb,thank you very very very much. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ GOAL SEEK

Hi Use SOLVER. In this case, the Subject to the Constraints : $N$2:$N$21=$O$2:$O$21 Set Objective : $N$2 To : Value of 7 By Changing Variable Cells : $F$2:$F$21 Subject to the Constraints: $N$2:$N$21=$O$2:$O$21 (Uncheck) Make Unconstrained Variables Non-Negative Select a Solving Method :

Re: $$Excel-Macros$$ GOAL SEEK

Sir, Please one more favor -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ GOAL SEEK

OH THAT'S REALLY GREAT, WHAT A ANSWER THANK YOU VERY MUCH SIR regarding solver I have another one could you please look at it. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ GOAL SEEK

Hi I tried using SOLVER and it is working. In this case, the Subject to the Constraints : $I$2:$I$15 = $A$2:$A$15 Set Objective : $I$2 To : Value of 15000 By Changing Variable Cells : $E$2:$E$15 Subject to the Constraints: $I$2:$I$15 = $A$2:$A$15 Check (Tick Mark) - Make Unconstrained

Re: $$Excel-Macros$$ GOAL SEEK

Hi I tried using SOLVER. It is working. But the issue is that constraint need to be mapped manually. In SOLVER: Set Objective : $I$2 To : Value of 15000 By Changing Variable Cells : $E$2:$E$15 Subject to the Constraints: $I$2 = $A$2 $I$3 = $A$3 $I$4 = $A$4 $I$5 = $A$5 $I$6 = $A$6 $I$7 = $A$7

Re: $$Excel-Macros$$ GOAL SEEK

Thanks Mr Sandeep Kumar Baranwal, I know this but I need the formula ok if there is no formula then can we do it thru SOLVER, if there is any possibility then can you do it, thanks in advance. I'm sure we can do thru SOLVER by applying different parameters *but the problem is what are those

Re: $$Excel-Macros$$ GOAL SEEK

Hi For the purpose of goal seek, we can apply formula. But this formula would work only on a particular cell. For Using Goal Seek formula, go on DATA/What-If Analysis/Goal Seek Goal Seek Inbox would be prompted Set Cell : I2 To value : A2 By Changing Cell : E2 Do it for repeatedly for all ,

$$Excel-Macros$$ GOAL SEEK

look at the attachment when we click on GOAL SEEK tab, place in the sheet, we see column E filled with the help of macro but if we want to apply a formula then how can be it possible. Is there any possibility. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ GOAL SEEK

in the attachment I have a macro in which GOAL SEEK has been specified. can anyone explain it to me how the figures in column E calculated when we press GOAL SEEK button in another word, I want to understand how this macro has been written -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

RE: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

U r Welcome! Regards, Muneer, CC.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ferry H Sitohang Sent: Tuesday, March 13, 2012 3:27 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Goal Seek

$$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

Dear Group, I want to select multiple cell values(a1 b1) to change the target cell C1. Can I do it like this? Plz suggest? If any formula or code, anyway that can do well plz send. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

May be this can help - http://www.vbaexpress.com/kb/getarticle.php?kb_id=433 On Mon, Mar 12, 2012 at 1:42 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Group, I want to select multiple cell values(a1 b1) to change the target cell “C1”. ** ** Can I do it like this? Plz

$$Excel-Macros$$ Goal seek in macros

Dear Friends, How can i use goal seek in macros in Microsoft excel? For eg: I prepare balance sheet of XYZ Co. and the component of the balance sheet are: Assets: Advances40 Investments 25 Bank Balance 25 Fixed Assets 15 Other

RE: $$Excel-Macros$$ Goal seek in macros

, 2011 1:37 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Goal seek in macros Dear Friends, How can i use goal seek in macros in Microsoft excel? For eg: I prepare balance sheet of XYZ Co. and the component of the balance sheet are: Assets: Advances40 Investments