Hi everyone!

I'm wondering if its do able to write a Macro that hardcopies content from Excel's data table function.

Situation
I've created a little simulation tool which has one input cell. There is some randomness involved and every time the result cell's value is slightly different. So I used Excel's data table function to provide me with 300 results in one column. Every time I press F9 the table refreshes with 300 new results. However, the distribution of the 300 results stays roughly the same so I'm happy with the reliability of the results based on one value for the input cell.

The problem
I now wish to generate such random lists for a large number of different values for the input cell. Manually this would be quite a lot of work and I suspect I'll have to repeat this little experiment more often in the future. So it would help me a great deal if a Macro could copy the values of the data table (in say column A), hardcopy it in a different column (e.g. B), change the value of the input cell and then make a new hardcopy of the results (e.g. column C) with the new input value. And repeat.

It would be nice if I could designate the number of hardcopies it should make and the increase in the input cell's value for each ''run''.

I've been trying to make a macro myself but without succes. It could be due to the fact that Excel needs to be able to refresh the sheet between hardcopies. Anyone willing to give it a shot?

Thanks in advance!

Best,
Ronnet