auto fill cells down a column

[eaje92]

Hi

I'm not sure if this is possible with excel but I am currently trying to simulate a reinforced learning algorithm using formulas. Basically what i am trying to do is automate a sheet whereby every time i press f9, an iterative calculation will be done in worksheet 1 and from there the results are placed in a column in worksheet 2.

For example,

Worksheet 1

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Action 1[/TD]
[TD]Action 2[/TD]
[TD]Action 3[/TD]
[/TR]
[TR]
[TD]Job 1 [/TD]
[TD]Job 2[/TD]
[TD]Job 3[/TD]
[/TR]
</tbody>[/TABLE]

So if i choose (for example) Action 2, The job to be processed would be Job 2. The jobs under the actions would be changing dynamically.

Worksheet 2

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]Jobs Chosen:[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]e.g 5[/TD]
[/TR]
[TR]
[TD]e.g 4[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

After pressing f9, the blank cell below will be automatically filled with the next "job chosen". I'm not sure if this is possible, but im looking for ways to make it work.

Thank you and much appreciated!