Challenge - Capturing all randbetween values in different cells

[kissthechef]

Hi,

I need the solution for the following:

1. Currently I have a randbetween() formula in cell B2.

2. Cell A1 = B2 (Every time the value in B2 changes so does the value in A1)

Instead,
I want that every change in value in cell B2 is captured in progressive cells.

For example:

First iteration in cell B2, value is entered in A1.
Second change in value in B2, value is entered in A2, while value in A1 remains unchanged and so on and so forth

Can any one help?

 

[Saagar]

Cross-posted

Original posting at http://www.mrexcel.com/forum/showthread.php?t=582803