goal seek

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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!

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