Hi everyone,
I would like help with coming up with a vba code which will help me generate 5 two digit number groups.. yes, this is lottery related... lol.....
anyway, say I have a number list, which could vary in length, starting in A1 and could go down as many as 40 numbers.
the numbers in the list could be any number between 01 to 60, never higher then 60. So it could look like this:
12
10
09
03
11
20
02
05
19
14
06
45
on down....
From this list I would like to generate sets of 5 2 digit groups, like this:
02 03 05 06 09
05 11 14 19 45
02 05 11 12 19
10 11 14 19 20
the lottery I'm tracking is 5/60... 5 numbers picked out of number range 01 - 60
I would like a box or drop down option where I could select the how many number groups are generated, 5, 10, 15, 20. So if I select 5, it will generate only 5 random groups of numbers taken from the list in column A.
The groups of numbers generated could start C1 and go to G1, and go down however many rows needed.
Also, if not to much, like in the video below, have 5 text boxes where if left empty, all 5 numbers would be picked from list. if I put in a number 5 say in the #2 text box, then all numbers generated would have the number 5 in the second position. similarly if I put a 55 in the last text box then all generated numbers would have for the last number 55.
but if I leave all text boxes empty then all 5 numbers would be picked for me... hope I haven't asked for to much.. but I just seem to figure out how to do it...
I found this link on youtube it is close to what I'm looking for. I've tried modifying it and all my pitiful attempts have failed miserably.... I can't figure out what to do.
youtube.com/watch?v=zMi6B984ynI
Thank you in advance to any help.
Dave
I would like help with coming up with a vba code which will help me generate 5 two digit number groups.. yes, this is lottery related... lol.....
anyway, say I have a number list, which could vary in length, starting in A1 and could go down as many as 40 numbers.
the numbers in the list could be any number between 01 to 60, never higher then 60. So it could look like this:
12
10
09
03
11
20
02
05
19
14
06
45
on down....
From this list I would like to generate sets of 5 2 digit groups, like this:
02 03 05 06 09
05 11 14 19 45
02 05 11 12 19
10 11 14 19 20
the lottery I'm tracking is 5/60... 5 numbers picked out of number range 01 - 60
I would like a box or drop down option where I could select the how many number groups are generated, 5, 10, 15, 20. So if I select 5, it will generate only 5 random groups of numbers taken from the list in column A.
The groups of numbers generated could start C1 and go to G1, and go down however many rows needed.
Also, if not to much, like in the video below, have 5 text boxes where if left empty, all 5 numbers would be picked from list. if I put in a number 5 say in the #2 text box, then all numbers generated would have the number 5 in the second position. similarly if I put a 55 in the last text box then all generated numbers would have for the last number 55.
but if I leave all text boxes empty then all 5 numbers would be picked for me... hope I haven't asked for to much.. but I just seem to figure out how to do it...
I found this link on youtube it is close to what I'm looking for. I've tried modifying it and all my pitiful attempts have failed miserably.... I can't figure out what to do.
youtube.com/watch?v=zMi6B984ynI
Thank you in advance to any help.
Dave