+ Reply to Thread
Results 1 to 5 of 5

Goal seek: How to set the "to value" to be a number in a cell and not a value

  1. #1
    Registered User
    Join Date
    07-21-2020
    Location
    Washington, DC
    MS-Off Ver
    365
    Posts
    20

    Goal seek: How to set the "to value" to be a number in a cell and not a value

    I would like to set a value for all of column H and I want the value in column D to change based on the set value in column H. I am using the goal seek feature but I'd like to create a macro where I can just type out a value in a cell on the sheet and have goal seek run automatically based on that number instead of having to repeat goal seek in each cell on column H many times for different values. Thank you in advance for reading and please let me know if I can clarify anything!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by planjb; 07-29-2020 at 11:03 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,463

    Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

    See the hint in a yellow banner near the top of the page.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    07-21-2020
    Location
    Washington, DC
    MS-Off Ver
    365
    Posts
    20

    Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

    Hi Kaper, I added an example of the excel to this post. I hope this helps clarify my question some more. Thank you, planjb

  4. #4
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    269

    Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

    If what you want to derive is Input value and Target level refers to % Left, then
    E8 = ($I$4*46000+G8-D8)/4400

  5. #5
    Registered User
    Join Date
    07-21-2020
    Location
    Washington, DC
    MS-Off Ver
    365
    Posts
    20

    Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

    Hi Josephteh, this solution is perfect! Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-24-2019, 08:18 AM
  2. Trying to automate "Goal Seek" in a worksheet
    By mjrubin23 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-28-2016, 07:37 PM
  3. Using Goal Seek - where I want the "To Value" to be a specific cell
    By Ainsley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2015, 06:52 AM
  4. [SOLVED] if formula needed to populate either "1" or "0" based on number of units in another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2015, 11:24 AM
  5. slow "goal seek" responding time:(
    By amanda1983810 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2011, 01:20 PM
  6. How to set the "to value" in GOAL SEEK as a cell reference?
    By phaidon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-10-2005, 05:45 PM
  7. [SOLVED] updating without "goal seek"
    By fredscott in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-28-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1