Macro Help for Random Number Generation

[robpike]

Hi everyone

I'm looking for some help in developing a macro to generate a monte carlo simulation of up to 50 separate lines of cost with a user defined number of random numbers, typically around 1,000. The formula to be used is (=NORM.INV(RAND(),J2,K2)) where J2 is the mean and K2 is the standard deviation of the Minimum, Most Likely and Maximum costs.

The attachment shows the intended layout of the information. The results of the monte carlo will be used to populate the last three columns with the appropriate percentiles for each cost.

I would anticipate that once the macro is run, the random numbers are fixed to allow reports to be extracted.

Any help will be greatly appreciated.

Rob