goalseek

I have a query I'm hoping someone can help with. Essentially I have the following formula in that gives me a final figure in C2: =((A2*1)/(1-B2))*1.12 A2 is a number B2 is a % What I want is to be able to have in D2 a goal number for an alternative outcome, and then a formula in E2 that tells...

I am trying to use GoalSeek in excel, however my problem is that the goal for goal seek changes based on goal seeks selected answer. Below I have a code that loops through goal seek, each time setting the goal to an updated value. There are many instances where this code works however, there are...

I am working on an excel model. I have successfully planted a VBA code for automatic calculation, but it only works if I change the targeted value manually (which in actuality is based on a calculation from another sheet). Long story short, VBA-coded Goal Seek is not reacting to an automatic...

Hi Have been learning VBA for ~24 hrs, so apologies what may be a straightforward question, but I am trying to write a code for the following: I have the following rows of data in my sheet: Row 21 in my sheet is a row of binary flag that either equals 1 or 0 Row 35 is a row of input values...

Hi, I am new to the forum and looking for some help... I am stuck!!:mad::confused: I am trying to use goal seek for a spreadsheet I am working on. When I use it i get a message that says "Goal Seeking with cell F4 may not have found a solution. The strange thing here is that when I do the maths...

Hi, I have a model that takes inputs to calculate the estimated cost of a new building. A second output is the estimated monthly payment to finance that cost. This output is based on one of two financing options, which a user selects from a drop down menu. The calculations for that monthly...

Hi All, I've got a goalseek within a VBA loop which comes up with an error. It works in isolation, and I've checked the obvious things like the cells in the goalseek linking and being formulae. I've turned auto-calc off, would this have an effect? Code below, bit where is goes wrong is...

Hello everyone. I'm fairly new to coding so bear with me. I have written a small goalseek code inside a for next loop. When the code runs I get an error at the end, probably because some other values in the sheet goes to zero before goalseek can do all the calculations. The error is Run-time...

I have this VBA, which is great, but in order to optimize it, I was wondering if there was a way to skip cells if two cells equal one another? here is the code: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Row = 248 And .Column > 7 And .Column < 556 Then...

Hi, I am very new to VBA and my piece-mailing some code I found through various forums, I was able to get my VBA Goal Seek to work. However, I have too many cells I want to goal seek. I've looked into how to try to sub routine my VBA but I'm completely lost. Any help is very appreciated...

Hi, I need a non-invasive custom VBA solver/goalseek function as follows: SOLVE(Output_Cell, Target_Value, Input_Cell) This would give the hypothetical value of the input cell that would give the target value in the output cell, but without actually changing the value in the input cell. It...

I'm a total VBA noob but for the workbook I'm making VBA seemed like the only thing that to get rid of the manual processes. I can't seem to find exactly how I would create or add something like this into my code. What I am doing: Running XIRR on hundred plus items. I built a sheet that runs...

Hello guys, I am doing a simple goal seek in VBA but I want that if the changing cell should be negative it appears a cero instead. I mean, limit the changing cell to 0 or positive numbers and avoid negative numbers. This is the macro that I am using: Range(A3).GoalSeek Goal:=Range(A2).Value...

Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+g ' Range("g68").GoalSeek Goal:=Range("g61"), ChangingCell:=Range("g63") End Sub Sub Macro2() ' ' Macro2 Macro ' ' Keyboard Shortcut: Ctrl+g ' Range("g78").GoalSeek Goal:=Range("g71"), ChangingCell:=Range("g73") End Sub hi. i have the...

hello. i have a corkscrew set up that stretches/repeats over 120 columns of data. i created a basic macro in VBA using the following syntax Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+g ' Range("g68").GoalSeek Goal:=Range("g61"), ChangingCell:=Range("g63") End Sub the...

Hello guys, Been a long time lurker of this amazing site. Lots of great resources. I need to do a goal seek on a large excel file line by line. I found the following Macro module that helps automate the process: Sub BulkGoalSeek() Dim C As Range For Each C In Range("A2:A10")...

I'm having trouble with my code for goal seek. It should be asking for input for the goal cell, but taking ranges for the other inputs. My cell G5/y has a formula. Using GoalSeek outside of VBA works perfectly. But using this code, I get a 1004 error "Reference Not Valid". The error highlights...

I have a macro which I use to do multiple Goalseeks in one go (one at a time). It normally works a treat, but in the model I'm working on at the moment, it's failing, because there are some UDFs in the sheet which are evaluating to #VALUE as soon as I run my macro. Goalseek works fine when I...

Hey guys. I need help for the following. I am SURE there is a faster code but I am new to coding and do not really know the commands for what I need to do. Below is the coding that I have now. ___________________________________________________________ Sub Solver() ' ' Solver Macro ' '...

I'm relatively new to excel and have been having an issue with some vba in this model i'm working on.... Essentially I want to run 3 goalseeks on the same dynamic variable (L63) and return the minimum value goalseek finds. The following are the procedures for each goalseek: <!--[if gte mso...