goal

So I'm trying to create a quick and easy goal seek macro, but every week the columns will shift over 1, so setting a static cell won't work. Is there a way to offset the goal seek or have it find a certain value and use that column? This is what I have so far, but I can't seem to get further...

I am new at utilizing the 95% of excel that I haven't used etc. etc…. I am very interested in getting better educated and your information is so helpful but I have a question about the doughnut progress chart. I am getting the hang of it but have revenue that exceeds goal and would like to show...

I am wondering if I can get suggestions from the experts here how best to proceed. I am trying to take my companies 10 sales goals and turn the monthly data into a dashboard so that my boss can quickly view progress. Each goal has a production number, goal, and deficit/surplus to goal. The goals...

I have uploaded to my Google Drive an Excel spreadsheet - https://drive.google.com/file/d/1JzPo1MSrQO44SOf1SBR6oRdPs34icPp2/view?usp=sharing There are two tabs, ORIG and DESIRED RESULTS. This is just a subset of a much longer file. The goal is to have all lines with the same address on one...

Good evening, I am having (a lot of) trouble attempting to put together a formula that properly calculates my organization's tiered bonus formula. Our managers are paid bonuses according to the following criteria: Goal: "X" units rented First Tier: 0-49.99% of goal reached, $0 (if you don't...

I am killing myself trying to solve a problem of pennies! Source 1 is a pricing sheet that has a total at the bottom. We frequently use goal seek to adjust margin to get a desired number. Accounting 2 is a sheet for accounting that takes numbers from Source 1 and regroups them. The numbers...

Hello All, I have a simple goal seek code in a sheet. However, we frequently add rows above where this goal seek happens. The BJ column will always be the same, but the row number will change. Is there any way to have the cell reference change in the VBA as the sheet expands/contracts? I've...

when i paste this i get #value! =SUM(IF('Shirt Database'!A2:A500,'Goal Keeper List'!B61,SUMIF('Shirt Database'!$F$2:$F$500,{"sub on","sub off","started","injured"},'Shirt Database'!$K$2:$K$500))) TIA

Hi All, After learning that Goal Seek is limited I started to better understand the Solver Tool. Can someone help me with the constraints to achieve my goal? This is my data (paste into A1) <colgroup><col span="2"><col><col span="2"><col><col><col><col><col span="6"></colgroup><tbody>...

I am having trouble adding one line to an IF function. I have learned that I can use up to 7 IF functions in a formula. My goal here is to get the difference between two dates and depending on the answer, the cell gives the green/amber/red answer. I have figured out my main goal, but got a...

This has been bugging me for some time now. How do you calculate a exponentially increasing Weekly Goal %, over a 52 week year, that sums to 100% at the end of the year. I don't have a particular starting point... just know the sum of the 52 week percentages has to equal 100%. This % is used...

Hi, Is there any way that you can solve the exact value of a cell say E9=21.09 using goal seek. I assigned a button for a macro that solves the value of a E9. The problem is for example I input a value say 5, goal seek will return a value of 0 for E9. Hope i could assign a restrain say...

Hi all, I have what i thought was a simple task, but cannot resolve. Simply put analysis server has millions of rows of data, i would like to be able to do download 1 day or one store only, like when using sql query and cell value. Set date or store and refresh. Not sure how to do this, please...

Hello, I have goal seek-ish problem. Think the regular goal seek function: Set cell A1 To value x By changing cell B1 What I want to do is based on the same principle how with one additional arguement, see below: Set cell A1 To value x and minimize cell C1 By changing cell B1 Is this...

I have never tried this before but ran into a roadblock. I have a macro that runs every time my worksheet is updated. The macro makes about 2 dozen calculations which are output to cells in a worksheet named "Holder" One cell of interest is calculated by this macro and is output to cell "B4"...

This is a duplicate post from ExcelForum.com https://www.excelforum.com/excel-general/1249308-creating-a-cell-that-is-uses-a-formula-to-provide-dollars-based-on-a-or-a-manual-entry.html#post4991488\ I am working on a sheet that projects the amount of money each month that should be put into an...

I am attempting to set up goal seek, and it keeps finding a negative number, no matter how many different ways I try to set up the formulas. I have added photos so maybe someone could help me? Thanks in advance!!

Hello. This is my first experience doing this... I am trying to automate a Goal Seek Calculation as follows: Goal Seek B24 To Value X (value for X is entered in cell B6) By Changing B26 Obviously I can manually do this through the Goal Seek box, but I want to be able to enter specified...

Hello Experts, I need your precious solution through VBA for the below query. I need to match these days in a row wise with the Goal set for the resources and highlight background color if that respective day is lesser than the Goal. for eg, Row1 : Goal : 40 ; Column 08/01/2018 : 45 Column...

Hi there. I have a Goal percentage and an average quarterly percentage. I need to calculate % from goal. Can you please help? Is it as simple as saying my avg Is 5.1% and goal Is 4.8% so I'm .3% from goal? The formula I have (used from predecessor) is =(5.1-4.8)/4.8 which =7.5%. (please...