Hi guys,

This is my 1st post here so hello to all, i frequently check the forum for little tips and have picked up a few useful things through this site. So thanks to everyone who contributes here for that.

I have a question to ask. I’ve made a scruffy little spreadsheet which I’ve attached. The end result will obviously look a bit tidier. I’ve set it out in a simple way so that I can explain what I want to do.. maybe someone can help me or at least push me in the right direction for what i am looking to do.

So..

Step A..
6 matches from Group D of Euro 2012, the percentage chance of each team winning and the draw is in the columns next to each match.

Step B..
A random number generator for each match. Creates a random number between 1 & 100.

Step C..
Depending on the random number it calculates how many points each team gets from the match. Eg France v England. France 35% chance of winning, draw 30% chance, England 35% chance. If the random number created is below 35, france win, if its between 35-65 the game is a draw, if its between 65-100 england win.

Steps D and E..
Calculate the league table based on the match results.

If you click on the calculate button a new set of random numbers will be generated and the league table reflects these results. Pretty straightforward.

What I want to do is to create a macro so that when you press the calculate button this process will be repeated x amount of times (say 10,000) and the league table results are recorded in the table at Step F. So for example out of the 10,000 times the league is played France may finish 1st 4000 times, come 2nd 2000 times etc etc.

I could do with a little help on how to create a macro to do this. I have a very limited knowledge of VBA so any help that anyone can give me would be much appreciated.

Many thanks!
League Table Example.xls