I have created a simulation that outputs it's result to B18. The simulated results are created using the RAND() formula and so I press F9 to re-run the simulator.
I would like to run this simulation 100 times and output the results in a table so I can find the average result.

Is there a way of re-running this simulator 100 times and collating the results in a table without having to manually press F9 myself and copy and paste the result
to the table?