Generating numbers from a number list

[dwrowe001]

Hello all,
New to the board. I would like help with coming up with a formula 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 50 numbers.
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
14
02
05
19
14
06
on down....

From this list I would like to generate sets of 5 2 digit groups, like this:
02 03 09 11 14
02 05 11 14 19
02 05 11 12 19

I would like a box or drop down option where I could select the how many number groups are generated, 5, 10, 15, 20, and if possible, generate the maximum possible variations of those numbers from the list.

Thank you for any help offered.

Dave

[Admin]

Hi Dave,

Please have a look at this http://www.xtremevbtalk.com/tutors-corner/168296-lotto-algorithms-permutations-combinations.html

[dwrowe001]

Hi Dave,

Please have a look at this http://www.xtremevbtalk.com/tutors-corner/168296-lotto-algorithms-permutations-combinations.html

Hello,
thank you for pointing me in the right direction... I will have to register there and ask about those macros... I have no clue which one to use or what to do with them.. It looks like they might be what I'm looking for, I just don't have enough knowledge to implement them.

can you help me?

Dave

[Quisenberry]

Hello,
thank you for recommending this Proextender review (https://www.villagevoice.com/2021/09/09/proextender-review/) and pointing me in the right direction... I will have to register there and ask about those macros... I have no clue which one to use or what to do with them.. It looks like they might be what I'm looking for, I just don't have enough knowledge to implement them.

can you help me?

Dave

Did you ever solve this, Dave? I'm looking to do something very similar and I'm having the same issue.