I need help creating a Monte Carlo simulation model in Excel. It's probably not as much of the Monte Carlo specific question per se but a question of approach to looking up corresponding values in probability table, suming and storing the results (in a temporary worksheet? or array? not sure what's best and how to achieve it), and moving on to the next simulation. Number of simulations is a user controlled input. I have created a skeleton of the model with some very high level VBA coding that for now that asks for user input for number of simulations, starts a blank "test" loop, and shows a progress bar. I need help/direction/guidance on the rest. My VBA knowledge would be best described as advanced beginner.