Results 1 to 7 of 7

Looping macro to run various scenarios through a model returning each answer automatically

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2016
    Location
    Launceston, Australia
    MS-Off Ver
    2007
    Posts
    4

    Looping macro to run various scenarios through a model returning each answer automatically

    Hi, hope is well.

    I have a financial model that works by the user entering 7 input assumptions that returns an answer.

    I want to be able to run (say 50+) different rows of scenarios using a looping macro to input each new row of assumptions and return the answer for each row using the financial model.

    Please find attached a basic example of my model. This example model simply sums the inputs together to calculate the answer, but I'm after a macro to do this task, as my real model isn't as simple as just summing the assumptions together, but the concept will be the same.

    Also I can't use the scenario manager as this requires each scenario to be input individually.

    Any help much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. returning right answer from 3 cells
    By sdtsdt in forum Excel General
    Replies: 1
    Last Post: 09-13-2015, 07:53 AM
  2. Nested IF Returning False - Need to Return True for Three Scenarios
    By rhelmer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2015, 05:50 PM
  3. [SOLVED] cells automatically colour differently with 'what if' scenarios
    By Kenny @ TLGC in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2014, 05:49 PM
  4. EVM Model that Updates Automatically
    By jylekarrett in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2013, 10:10 AM
  5. Formula sometimes returning correct answer and sometimes returning 0
    By redimp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2010, 06:28 AM
  6. Solver not returning answer
    By jealkon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2010, 05:15 PM
  7. answer: Returning a 0 Value
    By PeterAtherton in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM

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