Locked - Reason Title >>>Random question

i have made a selection of RAND() and i want to get the results on to another sheet but every time i put a formula on the second sheet the result changes, is there a way of it not doing this

That is the way RAND() works, it produces a new random number EVERY time EXCEL does a re-calculation.
Thus every time any change is made, or any toime you press function key 9 RAND() will give a new number.

If you want to get a set of random numbers, then keep them constant, use cut and paste special to paste back the VALUEs over the original FORMULAs.

Mark.