Hello folks,
Trying to figure out a way to have an array be looped and shifting items to the right as show in fig 1.
Figure1 lays out the pattern I'm trying to achieve via a macro with arrays and for next loop.
Yellow signifies the start of that "number group" for which we are looking for combinations of numbers.
so, each combo will have 100 cells, 10 rows showing possible combos.
So, if my thinking is correct I should have 1000 rows covering all combos by the time a "shift right" all the array "items" numbers I guess it would be.
fig1.
I have it doing this fig 2 so far.
fig2.
Trying to figure out a way to have an array be looped and shifting items to the right as show in fig 1.
Figure1 lays out the pattern I'm trying to achieve via a macro with arrays and for next loop.
Yellow signifies the start of that "number group" for which we are looking for combinations of numbers.
so, each combo will have 100 cells, 10 rows showing possible combos.
So, if my thinking is correct I should have 1000 rows covering all combos by the time a "shift right" all the array "items" numbers I guess it would be.
fig1.
Paired Matches.xlsm | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
O | P | Q | R | S | T | U | V | W | X | |||
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
2 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
3 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
4 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
5 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | ||
6 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | ||
7 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | ||
8 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | ||
9 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | ||
10 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | ||
11 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | ||
12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
13 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
14 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
15 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
16 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | ||
17 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | ||
18 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | ||
19 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | ||
20 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | ||
21 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | ||
22 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | ||
23 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
24 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
25 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
26 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
27 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | ||
28 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5 | ||
29 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | ||
30 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | ||
old1172022 |
I have it doing this fig 2 so far.
fig2.
Paired Matches.xlsm | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
O | P | Q | R | S | T | U | V | W | X | |||
33 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
34 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
35 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
36 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
37 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
38 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
39 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
40 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
41 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
42 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
old1172022 |