Goalseeking, that is important in simulation with numerical calculation model, is very boring work. So far, you have to open "GOALSEEK" window and input values in each run. This macro help you. Especially in case that you are a modeler, management consultant, an analyst in thinktank / investment bank, or you are in a corpolate planning office. You have to no longer repeat opening the "GOALSEEK" window. All you have to do is 3STEPs. STEP1: Constructing your numerical calculation model. STEP2: Set "Target" and "Parameter". Then the cells you use in STEP3 are colored. STEP3: Set "Target" and press the button and get the results. You can max. 20 cases in 1 macro running.
Requirements:
Microsoft Excel 2007/2010
Limitations:
3-day trial
Comments not found