Powerful Histogram Concept!

[redheadclay]

I am looking to create a chart detailing the distribution of an equation that has a random number generator as a component. So, the end result would be the above mentioned equation showing a normal distribution curve (or some other distribution curve - not sure yet!!).

Here is the catch. Lets say the answer before I refesh is 500. I press F9, and now it is 200. I want to run 1,000 iterations, but catch the value to each iteration and log it as a value...thus building the Histogram.

I'd like to stay out of writing code, and I would assume that there is a relatively easy way of doing it, but I can't seem to find it. I know I can create a macro, but that would take forever to set up (copying the result into line 1, press F9, copy result in line 2, etc for a 1,000 lines).
There must be an easier way, right??
Thx!

 

[Gerald Higgins]

There may be easier ways than this, but here's one simple modification of your solution -

Do the calc.
Copy the result into A2.
Insert a new row above A2.
Repeat 1000 times.