Simple Game and Puzzle - Very Difficult to Implement

[dmb490]

I am making this little game and I need this functionality:
1.
| Current Trial Input | Trial 1 | Trial 2 | Trial 3 |
_______ 4 ____________ 4
2.
| Current Trial Input | Trial 1 | Trial 2 | Trial 3 |
_____5 _____________ 4_____ 5

3.
| Current Trial Input | Trial 1 | Trial 2 | Trial 3 |
______ 2____________ 4______5______ 2

The difficulty I am having is the "memory" of storing previous trial
inputs. Basically each time a number is entered in the cell, it logs it
in an open cell to the right. Anyone know of a way to do this?

 

[Maistrye]

I am making this little game and I need this functionality:
Iteration 1.
| Current Trial Input | Trial 1 | Trial 2 | Trial 3 |
_______ 4 ____________ 4

Iteration 2.
| Current Trial Input | Trial 1 | Trial 2 | Trial 3 |
_____5 _____________ 4_____ 5

Iteration 3.
| Current Trial Input | Trial 1 | Trial 2 | Trial 3 |
______ 2____________ 4______5______ 2

The difficulty I am having is the "memory" of storing previous tria
inputs. Basically each time a number is entered in the cell, it logs i
in an open cell to the right. Anyone know of a way to do this?

You're probably going to have to do that with VB.

Although I'd be interested to see a formula that does the trick.

Scot