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!
Dim Answer As Integer
Answer = MsgBox("Run values?", vbYesNo + vbQuestion)
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.
From 1/7/2023 to 30/8/2023
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.
Dim count, lastrow, datenum...
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...
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
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:
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:
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)
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...
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...