+ Reply to Thread
Results 1 to 2 of 2

Using macro to test a number of possible scenarios

  1. #1
    Forum Contributor
    Join Date
    09-21-2007
    Posts
    196

    Using macro to test a number of possible scenarios

    At the moment I have a workbook which tests if, for a number of selections of 4 options (out of 21), they can be selected from a table of 4 columns which contain all 21 options spread throughout the 4 columns and possibly appearing in more than one column each, with one of the selections coming from each of the four columns. I can then see if the selections chosen are accommodated by the spread of options in the table. What I want to be able to do is, rather than put the options spread into the table, get excel to test all possible spreads of options and come up with the spread which fits the selections best. So effectively I would need a macro which can create the table and test it as my sheet does at the moment and come out with a % fit and then change the table and do this for all the possible spreads and come out with a list of %s to show the best fits. I can then hopefully work out a way to click on each of the possible spreads or % and it will show me what table it created for that. If anyone understands my ramblings, do you think this is possible to do? I have attached a simple sample sheet to try and show what I am talking about.

    Many thanks and any comments or ideas would be great fully received,

    Jack
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-21-2007
    Posts
    196

    Re: Using macro to test a number of possible scenarios

    Many thanks for everybody reading this thread. I am not interested in how to do it at the
    moment just whether it can be done.


    Many thanks for any input.

    Jack

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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