capturing all data from random formulas?

[excelNewbie22]

hi,
is there any way (except manually copy values) to save every data resulted from random formulas?
each time i hit F9?
for instance copy results from j2 : o2 onto q2:w2 and next one's to q3:w3 and so on
and if there's more rand formulas in j to o column's copy them too again and again (not overwrite)
maybe a macro?

test.xlsb
	C	D	E	F	G	H	I	J	K	L	M	N	O
2	1	2	3	4	5	6		4	1	15	14	5	11
3	11	12	13	14	15	16		5	16	4	11	15	13
4	1	2	3	4	5	6
5	11	12	13	14	15	16
6	1	2	3	4	5	6
7	11	12	13	14	15	16
8	1	2	3	4	5	6
9	11	12	13	14	15	16
10	1	2	3	4	5	6
11	11	12	13	14	15	16
test

Cell Formulas
Range	Formula
J2:J3	J2	=INDEX(TOCOL(C3:H10,1),RANDBETWEEN(1,12))
K2:K3	K2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:J2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
L2:L3	L2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:K2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
M2:M3	M2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:L2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
N2:N3	N2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:M2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
O2:O3	O2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:N2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:H3,C5:H5,C7:H7,C9:H9,C11:H21	Expression	=COUNTIF(#REF!,C3)>0	text	NO
I2072:I1048576,I1:I2052	Cell Value	=6	text	NO

 

[James006]

Hi,
May be with a formula =ISNUMBER(SEARCH("rand*",FORMULATEXT(J2)))

 

[excelNewbie22]

i think you got me wrong james,
i meant a way to save each results again and again in different columns
like this, did it manually just for example

test
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1															wanted result generated from j2:o3
2	1	2	3	4	5	6		4	16	5	15	2	12		13	3	2	12	14	16
3	11	12	13	14	15	16		4	3	2	5	13	11		15	11	16	1	5	12
4	1	2	3	4	5	6									3	2	5	1	4	14
5	11	12	13	14	15	16									1	16	4	12	3	13
6	1	2	3	4	5	6									3	4	11	6	2	1
7	11	12	13	14	15	16									11	16	6	12	14	5
8	1	2	3	4	5	6
9	11	12	13	14	15	16
10	1	2	3	4	5	6
11	11	12	13	14	15	16
test

Cell Formulas
Range	Formula
J2:J3	J2	=INDEX(TOCOL(C3:H10,1),RANDBETWEEN(1,12))
K2:K3	K2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:J2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
L2:L3	L2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:K2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
M2:M3	M2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:L2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
N2:N3	N2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:M2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))
O2:O3	O2	=LET(a,TOCOL(C3:H10,1),f,FILTER(a,ISNA(MATCH(a,J2:N2,0))),INDEX(f,RANDBETWEEN(1,ROWS(f))))