goal seek

  1. S

    VBA Help Goal Seek with dynamic cell

    Good day all! I'm trying to make a goal seek function but the change cell target is dynamic based on a certain cell. Hoping to have some help or improvements on the below. Thank you! Sub GoalSeek() Dim Answer As Integer Answer = MsgBox("Run values?", vbYesNo + vbQuestion) If Answer...
  2. M

    Goal seek issue

    I have a sheet (Attached), where I want to change the value of the total billable hours to reach a target utilization, but it's not working properly, appreciate any pointers. A B C E F G H I J K From 1/7/2023 to 30/8/2023 Working Days Target Hours Available for Work To be charged...
  3. W

    Using goal seek within VBA

    The VBA code I have written uses goal seek within the code but it's returning values that are vastly different than if I run a manual goal seek for each sheet. I have pasted the code below and can attach the reference files upon request. Sub UpdateAndSolver() Dim count, lastrow, datenum...
  4. K

    Goal seek with intermediate iterations

    Howdy all! I've got a problem that requires tweaking one input then running a pile of iterations between tweaks to the input. Basically a goal seek with ten or twenty thousand iterations per cycle....imagine sitting a through a whole tv episode with your finger on f9 ;) Check if the...
  5. B

    Goal seek_ changing cell reference

    Can i run goal seek in vba by referencing the "Changing cell" from some other worksheets but the same workbook. Please help.
  6. B

    Goal seek for multiple sheets

    I have multiple sheets (30+ sheets) and I need to use goal seek analysis at once for all the sheets. Is it possible? Please help. It would really save me a lot of time.
  7. J

    Data Tables & Goal Seeker

    Hi All, First time poster here and looking for help on what I believe may lie with data tables / goal seek. My spreadsheet currently has many formulas but can be simplified to: Margin = (Price - Costs) / Price I am looking to answer a question: ‘What would my price have to be if costs...
  8. A

    Goal Seek shows correct answer but won't stop iterations

    I am running goal seek on two different workbooks. WB1 has an interest rate that modifies the value of the other workbook via basic multiplication. I am goal seeking the sum of the products. When I step through the goal seek iterations, it lands precisely on the sum I want. But goal seek...
  9. S

    Determining Purchase Price on Real Estate Transaction using Goal Seek, NPV, and IRR

    I work in commercial real estate and we are trying to back into a purchase price by determining what initial outlay gets our NPV to 0 and IRR to 30%. Essentially, what acquisition price gets us to a 30% IRR. We're looking at this over a three year period. For purposes of simplicity, say I can...
  10. A

    Goal Seek Not working

    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...
  11. P

    Re: Goal seek function in excel

    Re: Goal seek function in excel Guys, I am having some challenges with the MS Excel GOAL SEEK function. It worked alright for the first few times that I used it to work out the EFFECTIVE INTEREST RATE for the issuance of bonds. However, it is now coming back with absurd results...
  12. T

    Automate goal seek in two separate worksheets?

    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...
  13. C

    how to use goal seek for multiple columns that match search criteria

    I am trying to use a goal seek for every column that contains “2700” in row 38. If a column has “2700” in row 38, I’d like row 130 to equal 5 by adjusting row 50. Please note, in the row 38 contents it can be 2700 or a number of 2700 and letter combinations, which is why I have to do a search...
  14. R

    Modelling with Multiple Variables

    I have a financial model forecast that is based off a number of variables on an input sheet. I'm trying to create a matrix that shows the following: <tbody> Year 1 Year 2 Year 3 Year 4 Year 5 Variable 1 Variable 2 Variable 3 </tbody> In each cell I'd like to calculate...
  15. N

    Help, formulas/goal seeking

    Hi guys, I have this problem and cannot solve. So I was hoping on some help. I can solve this problem with goal seeking, but this is not dynamic. Maybe you have a better solution. So I have the following: <tbody> <tbody> Total budget </tbody> <tbody> campaign1 </tbody> <tbody>...
  16. E

    Goal Seek Formula or Same function Formula

    Hello i have the following table, i have to do goal seek formula on every row to get the value Column H to 0 by Changing in Column B Could I Change the Number in Column H to zero for All Rows in one Step (preffered not using VBA) <colgroup><col span="8"></colgroup><tbody> A B C D E F G H...
  17. L

    VBA Code for bulk Goal Seek

    I'm trying (and failing:laugh:) with some VBA code to make a 'Bulk Goal Seek'. My Goal Seek is as follows: Set Cell Range is G2:G1001 Value I want is 12.00% Change Cell Range is B2:B1001 So I want to Goal Seek Cell G and convert it to 12% (or closest match) by changing cell B. The other cells...
  18. X

    Rounding in VBA

    Hello, I am working on a spreadsheet that I have a goal seek function to find the optimal number of units based on certain parameters. My problem is that I need to round these numbers up or down depending on which one it is. I found a solution that mostly works but sometimes it does not act...
  19. C

    Goal seek to determine IRR for a series of cashflow by changing the initial outlay

    How do i obtain a target IRR by leaving my cashflow fixed and changing my initial outlay using goal seek? I am trying to determine what my initial cashflow will be to obtain a target IRR with a fixed series of cashflows. Thanks in advance!
  20. K

    Automated Macros on Formula Value Changing

    Hi, I'm new to VBA but for a project I'm working on, the calculations require a series of formulas which have to be manually carried out such as several goal seeks. So far I have been able to enable them with a series of macros with a worksheet selection change such as below. Also the macro...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back