Permutations of 6 grouped

[Romakes]

Hi Guys,

Ive been working on some scripts to generate a lucky number set for myself to use for Lotto.
I have a macro that i can use as well to get all permutations of the numbers but what i actually need is permutations per ball.

For ex.
I have for the ball values the following

Ball1 =(1,2,3,4,5)
Ball2 =(4,8,9,14,21,22)
Ball3 =(9,23,25,27,29)
Ball4 =(22,23,29,30,31)
Ball5 =(35,36,38,37,40)
Ball6 =(40,41,42,43,49)

Each ball is in its own column starting at A1 through to F1 being Ball 6
What I need is all the permutations of this using excel but Balls in A1(Ball1) needs to stay Ball1 and Ball2 needs to stay ball2 and so on.
a Ball number that is in A1 only can only be a ball 1 and not all columns have the same amount of rows in them either.
I think this will give me less combinations but still using the numbers I predetermined.

Thanks

[Romakes]

Also if this has already been posted really sorry about that, ive only been finding ways of calculating all permutations and alot of them I dont need. Thanks

[Romakes]

Here is a better example i think.
for this set of numbers
1 2 3 4
5 6 7 8
9 10 11 12
This is what I would like to results to be like.
1 6 7 8
5 10 11 12
9 2 3 4

1 10 11 12
5 2 3 4
9 6 7 8

1 2 7 8
5 6 11 12
9 10 3 4

1 2 11 12
5 6 3 4
9 10 7 8

1 2 3 12
5 6 7 4
9 10 11 8

1 2 3 8
5 6 7 12
9 10 11 4
Ive done all the sql and other macro's for this but having problems getting this macro. thanks

[shg]

There's a workbook with formula-based and VBA-based methods at https://www.box.com/s/47b28f19d794b25511be

[Romakes]

Shot dude thats awesome, this is exactly what i needed , not sure how to edit the formula page tho but will look into it , looks like a better way of doing it then i thought about.

[Romakes]

shg whats the type of code called used for the formula tab please? I'd like to learn to edit it, i think it can be tuned abit.