goal seek

I have been using the following Macro to set prices for a given Profit on Return. (sounds somewhat unnecessary as I could use a formula the other way around - however it is necessary and this is the favored way of doing things) However with a list of products there is inevitably a subheading...

I'm trying to use a macro to produce a value in a column of cells, based on 2 other cells in the same row. I'm obviously missing something as I keep getting a 1004 error "reference not valid." Code: Sub Macro1() Dim i As Integer For i = 2 To 23 Cells(i, 18).GoalSeek Goal:=Cells(i, 2).Value...

Hi I couldn't find a similar topic for this question, so sorry if one already exists. I am trying to do a goal seek 100 times if a certain condition is true. The first goal seek is on cell R104, where the target value is R103 and the variable cell is Q104. The next goal seek is cell R110...

I am trying to run an automatic goal seek via a button and am not sure what the Macro <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250...

I am trying to run an automatic goal seek via a button and am not sure what the Macro VBA code should be. The forumla should ideally auto calculate (without having to press the button if possible). The calculation is to determine an initial loan repayment amount (cell I10). Depending on the...

Hi All, I have a financial model that I use to report and forecast past and future results. It is set up over multiple pages, starting with an inputs page where all model inputs are input and an actuals page for all actual results to be input as they occur. Other pages provide information...

Hello members of this great forum. First time post but longtime viewer :p As you could get; I have a problem.. I have 300 lines of products, i'll take MILK as an example. I need 13,3 liters of milk, and they sell them in 2 quantities; 5 liters and 1 liters. As you could guess i should buy...

I am using Excel 2010. I want to use a relative reference to goal seek using a "ChangingCell" that is in a different worksheet... ActiveCell.GoalSeek Goal:=0, ChangingCell:=Sheets("Volumes").Range("O11") ... but I am getting an error message that the reference is not valid. What...

So I'm working on a macro that will utilize GoalSeek to make calculations faster. Working code.... Dim CellToChange As Range 'Trouble Starts CellToChange = Sheet4.Range(Selection.Address) Call maxoutform.FindMyNutritent(ComboBox1.Value) Selection.Offset(0, -3).Select...

How do I create a VBA macro in Excel that uses the goal seek function? Set Cell: C49 To Value: (whatever I have in cell L47) By changing cell: B19 As I change the value in cell L47. I want the macro to automatically run in the background.

Hello, I am wondering if there is a way to have excel run iterations to find out when one cell would be equal to another. As an example: Say I have an INPUT of 5% which generates an output of $10 I have another INPUT of 7% which generates an output of $20 I know these two eventually...

HI, Is there a way to omit minus numbers in goal seek? Thanks..

Greetings - I've been asked to see if I can improve the performance of a worksheet using Goal Seek in VBA code. It's pretty simple however the Goal Seek call itself takes literally 2-3 seconds to return - not a big deal except this routine iterates through 20,000 - 30,000 rows adding up to more...

I have a macro set to run every time cell B6 changes (specifically, the macro uses "On.Entry" to run a Goal Seek every time B6 changes). I also have a data table with B6 as the "input" cell. But the data table outputs do not reflect the Goal Seek results of the macro that would run if cell B6...

Is there a way to restrict solver from changing the varibles (cells allowed to change)? I have an optimization problem where only a certain amount of records can be used and I have to find the optimal solution. I am using 1s and 0s (1,0) to determine if the record should be included or not...

A3 is where I input a decimal number which changes quarterly A2 is a factor which I also input quarterly B3 is (A2*A3)/12 This goes on for A3>A6 and B3 through B6 I do this because I do not know B3 through b6 as individual values but I am given their sum in B7 which I can enter as well but...

IThe following is an example data set: New Price ?? this is what I want to solve Customer Units Price Gross Margin Ext Price Ext Margin ABC...

Hi Everyone, I know there are a few threads for this already, but I have a specific question that doesn't seem to be covered, rather than dragging up old threads that could get messy, I thought I would start a new one. I found some script on this forum similar to the one below (just tweeked the...

Hello, I've been looking around for an hour or so and have found a couple of great ideas about how to bypass goal seek for interest and payment items, but i can't figure out how to adapt them to my scenario... If anyone can help out I'd appreciate it! I'm looking for a way to solve for the...

Hi everyone, I have a fairly large excel file (~21MB) with a macro which performs about 400 goalseek runs. This macro has to run everytime a change is made in any of the 13 key input cells, and hence, should be pretty fast. The problem is that it currently takes about 8-10 minutes to run, a...