Need VBA macro to list combinations from data from left to right only, please!

[Estatefinds]

So I need a macro that will run in which the data in column DC the first digit will be placed for example the number 6 then it will look in the next column labeled row 2 for the next digit higher which would be 13 then I t would look in the next column labeled row3 the next number higher which would be 14, then to the next column labeled row 4, the next number would be 15, then to the next column labeled row 5 the next number higher up would be 24; Until five numbers make up the combination. The combiations will only be made left to right until all possible combinations are resulted in column GC13.
Then it would start at lowest number in column DD for example will start with the number 1 and result all combinations into column GD13.

6	1	4	2	9	19	5	32	18	7				3	28			31	11							20
8	13	10	15	24	21	12
17	30	14	16	33	27	22
23		26	25		35	29
34
Row 1	Row 2	Row 3	Row 4	Row 5	Row 6	Row 7	Row 8	Row 9	Row 10	Row 11	Row 12	Row 13	Row 14	Row 15	Row 16	Row 17	Row 18	Row 19	Row 20	Row 21	Row 22	Row 23	Row 24	Row 25	Row 26	Row 27	Row 28	Row 29	Row 30	Row 31	Row 32	Row 33	Row 34	Row 35

<tbody>
</tbody>

6-13-14-15-24
6-13-26-33-35
and so on

also no number can be used from the same Column meaning a value from row 1 be used with a row 1 value the combinations will be built from smallest value to largest left to right only.
Thank you!
Sincerely Dennis

 

[Estatefinds]

if you need more information or more detailed description let me know.
Thank you!

 

[Estatefinds]

the combinations that start with the first value of the combination that is found in the column labeled Row 1 will be listed below in the column labeled row 1. the combinations that start with the first value of the combination that is found in the column labeled row 2 will be listed below in the column labeled row 2 and so on until no others combinations can be made from left to right.

 

[Estatefinds]

Row 1

Row 2

Row 3

Row 4

Row 5

Row 6

Row 7

Row 8

Row 9

Row 10

Row 11

Row 12

Row 13

Row 14

Row 15

Row 16

Row 17

Row 18

Row 19

Row 20

Row 21

Row 22

Row 23

Row 24

Row 25

Row 26

Row 27

Row 28

Row 29

Row 30

Row 31

Row 32

Row 33

Row 34

Row 35

A1

A2

A3

A4

C5

B6

A7

E8

C9

B10

A14

E15

E18

B19

C26

B1

B2

B3

B4

D5

C6

B7

C1

D2

C3

C4

E5

D6

C7

D1

D3

D4

E6

D7

E1

6

1

4

2

9

19

5

32

18

7

3

28

31

11

20

8

13

10

15

24

21

12

17

30

14

16

33

27

22

23

26

25

35

29

34

Row 1

Row 2

Row 3

Row 4

Row 5

Row 6

Row 7

Row 8

Row 9

Row 10

Row 11

Row 12

Row 13

Row 14

Row 15

Row 16

Row 17

Row 18

Row 19

Row 20

Row 21

Row 22

Row 23

Row 24

Row 25

Row 26

Row 27

Row 28

Row 29

Row 30

Row 31

Row 32

Row 33

Row 34

Row 35

6-13-14-15-24

1-4-15-24-27

6-13-14-15-33

1-4-15-24-35

6-13-14-15-27

1-4-15-24-29

6-13-14-15-19

1-4-15-24-32

6-13-14-15-21

1-4-15-24-28

6-13-14-15-27

1-4-15-24-31

6-13-14-15-35

an so on

6-13-14-15-22

6-13-14-15-29

6-13-14-15-32

6-13-14-15-18

6-13-14-15-28

6-13-14-15-31

6-13-14-15-20

an so on

<colgroup><col><col span="2"><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Estatefinds]

OK SO i HAVE A CORRECTION same concept but the macro needs to look at smallest number and look to the left of where it is and look tothe next number up to build a combination of five numbers and build all possible combinations to the left of where this number is found and id there are not enough numbers to the left to build it, it will look to the right and build combinations. so for example for smplicity it look at the value 7 in the column DL labeled row 10 it will look to the left of the column DL and take a number that is higher than seven and start to build a combination and take one value from each column to the left. and it will keep doing this until all combinations are made and place these results in column GL which is labeled row 10 but the results will be placed at location on worksheet GL row 21 which the GL column is labeled ROW 10. then once the left direction of the combinations are done it will look to the right of where the 7 value is found to see if it can take a number higher than 7 to start building a five value combinations. so if you look in the data example the value of 7 which is labeled row 10 the numbers to the right are 3,28,31,11 so the the macro would look at this and see a five number combinations cant be made cause it starts from left to right at the 7 so for example 7 the next number up is 11 then 28, then 31 there are only four numbers so this wouldnt work it would stop there. and do a another search through all the values in the data DC13 to EK17.
here is a clip from the data so the value 6 only looks to the right as there is no data to the left to look for numbers to build a combination from right to left, but does from left to right and since the number 6 is found in the column DC labeled column row 1 the combination results get placed in the column. also the resulted combinations will be placed in columns GC to HK starting on row 13. which are labeled row 1 to row 35 on row 12 for the label. also keep in mind the value the combination starts with and which ever labeled row it is found those results will go in under that labeled row. so for the value of 6 below it is found on labeled row 1 so all the combinations starting with value of 6 will go in the labeled row 1.

6	1	4	2	9	19	5	32	18	7
8	13	10	15	24	21	12
17	30	14	16	33	27	22
23		26	25		35	29
34
Row 1	Row 2	Row 3	Row 4	Row 5	Row 6	Row 7	Row 8	Row 9	Row 10
6-13-14-15-24	1-4-15-24-27
6-13-14-15-33	1-4-15-24-35
6-13-14-15-27	1-4-15-24-29
6-13-14-15-19	1-4-15-24-32
6-13-14-15-21	1-4-15-24-28
6-13-14-15-27	1-4-15-24-31
6-13-14-15-35	an so on
6-13-14-15-22
6-13-14-15-29
6-13-14-15-32
6-13-14-15-18
6-13-14-15-28
6-13-14-15-31
6-13-14-15-20
an so on

<tbody>
</tbody>