Simulation

Hi, could someone please help me. I have a very basic knowledge of how to use macros, but very basic.

I am creating a simulation model which produces an output in one cell. The model is based on the RAND function, so the model output changes with every action I do within Excel. I want to record this output in a separate column as the model cannot be easily replicated manually. Ideally there should be a 1000 iterations of the model.

Does anyone have a macro code available which I could use?

Many thanks.

Yes the output of a 1000 iterations of the model stored in a column, where the results won't change.

Brilliant, that worked perfectly. Thank you very much.