Hi, so this might be a complex task but here goes.
Essentially, I have a sheet set up to randomly select one of 12 options based on a weighted number (i.e. options with a higher number are more likely to be chosen). I use this to ‘simulate’ races and assign points to the randomly selected options, starting with first place, then zeroing out the weights and then for second, and so on. Now this is very easy to do manually, but I’d like to know if this can be done with a macro.
I have another sheet set up for inputting the results of these races, where I put the number of points each person scores next to their name for each race. There are 12 races in total.
Now, what I would like is a macro that reads the output of the randomiser and puts the appropriate number of points in the appropriate column next to the appropriate player (maybe by reading how many zeroed-out weights there are).
Sorry if the explanation makes no sense. But thank you if you can help.
Cheers