+ Reply to Thread
Results 1 to 3 of 3

Automatcally retain the original data after solver is ran but w/ new data on a blank cell

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    5

    Automatcally retain the original data after solver is ran but w/ new data on a blank cell

    Whenever Solver or goal seek is ran, the original value is replaced with a new value. How can I keep the old value yet show the new value on a blank cell or a separate sheet automatically?

    This is a really basic example,


    A1 = 200
    A2 = 100
    A3 = 100

    A3=A1-A2

    And if I set A3 to 0 by changing A2 in Solver or Goal Seek, I will get 200 in A2. 200 is the break-even amount I'm looking for but I still want my original data. And I don't want to memorize and write down the new result each time I ran solver/goal seek...and then click cancel to restore to the original data...is there an easier way to do this?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,474

    Re: Automatcally retain the original data after solver is ran but w/ new data on a blank c

    They are not tools I use very much, but you might look at "what-if analysis" http://office.microsoft.com/en-us/ex...164.aspx?CTT=1
    Solver also has a "save scenario" option that may allow you to easily do what you want. http://www.solver.com/content/basic-...esult-messages
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    05-29-2014
    Posts
    5

    Re: Automatcally retain the original data after solver is ran but w/ new data on a blank c

    I did play around with the save scenario, however, the user would have to go through that process of finding the scenario manager and click the saved scenario and showit...which still changes the original cell value to the new value and I don't want that.
    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. Drop Down to retain Original Fill
    By joecast4184 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-27-2013, 11:39 AM
  2. Retain formatting of original list (Data Validation)
    By demonfly100 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-28-2012, 07:19 AM
  3. Replies: 0
    Last Post: 01-14-2012, 02:13 AM
  4. Retain copy after original changed.
    By Basher99 in forum Excel General
    Replies: 1
    Last Post: 08-13-2009, 12:44 PM
  5. [SOLVED] Why will solver only return the original adjustable cell values?
    By Del in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-03-2005, 12:06 AM

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