VBA Generate random 10 Group of 5 numbers

[motilulla]

Hello,

Looking VBA solution which generate random 10 group of 5 numbers using all 50 numbers in cells D2:H11
List of numbers is in cells A2:A51.
If all numbers are used in to cross check C1 will show sum of 50 numbers = 1275
Example…

Book1
	A	B	C	D	E	F	G	H
1	Numbers		1275	n1	n2	n3	n4	n5
2	1		Group1	34	41	9	20	23
3	2		Group2	21	15	50	5	7
4	3		Group3	19	11	18	30	8
5	4		Group4	32	13	48	12	31
6	5		Group5	1	43	46	39	38
7	6		Group6	36	49	16	26	33
8	7		Group7	10	44	35	27	37
9	8		Group8	25	17	3	45	24
10	9		Group9	40	42	2	14	29
11	10		Group10	4	28	22	47	6
12	11
13	12
14	13
15	14
16	15
17	16
18	17
19	18
20	19
21	20
22	21
23	22
24	23
25	24
26	25
27	26
28	27
29	28
30	29
31	30
32	31
33	32
34	33
35	34
36	35
37	36
38	37
39	38
40	39
41	40
42	41
43	42
44	43
45	44
46	45
47	46
48	47
49	48
50	49
51	50
Random-50

Cell Formulas
Range	Formula
C1	=SUM(D2:H11)

Thanks In Advance
Using version 2000

Regards,
Moti

 

[B___P]

Putting into play all numbers, for the pidgeon hole principle, you have at least 5 numbers guessed right...
Have a nice evening, I'm going to watch Wales-Belgium on tv.

 

[motilulla]

Putting into play all numbers, for the pidgeon hole principle, you have at least 5 numbers guessed right...
Have a nice evening, I'm going to watch Wales-Belgium on tv.

B___P, Cheers I am watching also you too have a nice and pleasant evening

Good Luck

Moti