Generate lines of 50 numbers (00 to 99) without repeating the 25 letters of the 4 quadrant

Generate lines of 50 numbers (00 to 99) without repeating the 25 letters of the 4 quadrants! please
Phase A - base numbers

1. Choose 4 random letters of 25, assign them to 4 numbers from quadrant 1

2. Choose 4 random letters of remaining 21, assign them to 4 numbers from quadrant 2

3. Choose 4 random letters of remaining 17, assign them to 4 numbers from quadrant 3

4. Choose 4 random letters of remaining 13, assign them to 4 numbers from quadrant 4



Phase B - completing the game

1. Take the remaining 9 letters and assign them to corresponding numbers in each quadrant - you get 36 numbers

2. Choose 2 random numbers of these 36 to eliminate, you are left with 34 numbers

3. Combine these 34 numbers and the 16 base numbers to get a game of 50 numbers
Example = I choose 01 = I can not play 06 51 56, because it's the same letter A

a b c d e a b c d e
f g h i j f g h i j
k l m n o k l m n o
p q r s t p q r s t
u v w x y u v w x y

a b c d e a b c d e
f g h i j f g h i j
k l m n o k l m n o
p q r s t p q r s t
u v w x y u v w x y

01 02 03 04 05 06 07 08 09 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50


51 52 53 54 55 56 57 58 59 60
61 62 63 64 65 66 67 68 69 70
71 72 73 74 75 76 77 78 79 80
81 82 83 84 85 86 87 88 89 90
91 92 93 94 95 96 97 98 99 00

corret 4 quadrant
ttp://www.mediafire.com/file/18l0w8irbu7fl0r/quadrantes_corret.xlsx

Hello, zbor, I just mentioned the directives (the bases), so that someone can help me in generating lines of
50 numbers, in the mentioned criteria, someone with knowledge in randon

Hello, what is the question on the question? Makro has to create lines of 50 numbers in the criteria of 25 letters of no repeat,

seems like just a bunch of loops using 2 sheets to slowly delete the letters and numbers available? or arrays but i'm not the best with arrays. good learning experience though

Hello sparky 347, thanks for watching, the post, in the 1st post the 4 groups of letters (25 every 5x5)
It was out of focus, what is worth is the link of the planilia,
Since we have 4 quadrants, (5x5) and 25 letters (the letters actually are to see the same 25 positions in the 5x5,
I choose, randomly 4 letters in the 1st quadrant do not repeat in the remaining 3,
Objective = do not repeat the letters after choosing the reference group. Please

Well I see you posted a link that I can't access. And this really does seem like a school project as stated above. Therefore I would ask you post a workbook with what you have so far?
The issue does not lie with understanding what you want the macro to do but that we would like you to put an effort in as well

Phase A - base numbers

1. Choose 4 random letters of 25, assign them to 4 numbers from quadrant 1

2. Choose 4 random letters of remaining 21, assign them to 4 numbers from quadrant 2

3. Choose 4 random letters of remaining 17, assign them to 4 numbers from quadrant 3

4. Choose 4 random letters of remaining 13, assign them to 4 numbers from quadrant 4



Phase B - completing the game

1. Take the remaining 9 letters and assign them to corresponding numbers in each quadrant - you get 36 numbers

2. Choose 2 random numbers of these 36 to eliminate, you are left with 34 numbers

3. Combine these 34 numbers and the 16 base numbers to get a game of 50 numbers