+ Reply to Thread
Results 1 to 2 of 2

Using SOLVER add-in multiple times

  1. #1
    Registered User
    Join Date
    02-05-2018
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2016
    Posts
    3

    Using SOLVER add-in multiple times

    Hello there,

    I am using solver to maximize the value of a certain cell. I have number of constraints and everything is working fine. My problem is, that I have over 700 lines of data, and that would mean I would have to manually plug my data into solver 700 times. Is there any way to automate it? Simple example so it is perhaps easier to understand.

    Maximize value of $A$1,
    by changing variable cells $B$1:$F$1,
    subject to constraints:
    $G$1:$K$1 <=1
    $L$1 = 1
    $M$1:$R$1 <= 0,3

    As you can see, every variable is present in the same row, and I have over 700 rows of data. The only thing that should change in the solver is the row number.

    Thanks for any help, or advice in the right direction.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Using SOLVER add-in multiple times

    Set a reference to Solver, then
    Please Login or Register  to view this content.
    Change EngineDesc to whatever you're using.
    Last edited by shg; 12-04-2019 at 01:09 PM.
    Entia non sunt multiplicanda sine necessitate

+ 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. Trying to Run Solver multiple times
    By cmcgough in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2017, 05:36 PM
  2. How to Run Solver Multiple Times
    By cmcgough in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2017, 04:41 PM
  3. Replies: 1
    Last Post: 04-27-2016, 03:05 PM
  4. Creating a Macro That will Run Solver Multiple Times
    By Otaishtf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2013, 10:28 AM
  5. Run Solver Multiple Times (while changing constraints and goal for each iteration)
    By pmw1218 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2013, 04:17 PM
  6. Using Solver Multiple Times In One Sheet
    By g1362901 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2009, 09:02 AM
  7. Using Excel Solver multiple times with macros
    By Barry T in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-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