The simplest approach is to use a worksheet change event macro. This type of
macro will automatically run every time the worksheet changes. The macro can
detect if your result cell has changed and record this result in the first
available un-used cell in another column.

For your purposes, it's better to use a column since a row can only hold 256
values.
--
Gary's Student


"warren_ds" wrote:

I want to run a bunch of trials with random numbers. Each trial will have a
single numerical result (in a single cell). I'd like to be able copy the
result value (or use an equality equation) of a trial into a cell somewhere
else, and then run the trial again (new random numbers), and then have the
new result pasted into the NEXT cell below (or next to) the first, and so on,
lots of times, so that I end up with lots of results from my trials. Is
there a way to basically have Excel automatically increment the cell row or
column (I don't care which -- I can grab the data wherever it is) each time I
run a new trial? Sounds a little complicated, but the idea is pretty simple.
I don't want to have to manually copy and paste the "value" of the result
each time -- I'd like to run hundreds or thousands of trials.
--
Thanks.
Warren