Hi - I have sales pipeline data with a dollar value and a probability of success for a number of deals. I'd like to generate a random number between 0 and 1 for each of these deals for each of 500 trials. From each trial, I want to output the sum of all dollar values where the randomly generated number is less than or equal to the deal probability.
The attached excel contains some sample data with this loop working through a data table. I'm trying to build an iterative macro to handle this, but I can't seem to get it to loop the way I want it to. I want the output to have as many rows as the the macro has iterations.
