I've used excel to build a rule-based simulation of organizational behavior. Random numbers, generated by excel's "Rand()" function, underlie the whole thing. Therefore, every time I run the simulation, it produces different results (as it should). There are several-hundred million possible values that could result from the simulation, so my goal is to run the thing 1,000 times, in order to get a good feel for the total range of the outputs possible within my model. I would like to find a way to automate this, so that I don't have to copy and paste values from the output cells 1,000 times manually. Indeed, I have five other versions of the model, each of which I need to run 1,000 times (possibly more), so I really need a solution that I can easily apply to different sheets. This seems like it should be easy enough to accomplish using some type of loop, but by inexperience with VBA has prevented me from determining a solution. Can anyone help?
I can provide more detail if my question is too vague. Thanks in advance for solving my problem.
Bookmarks