VBA to run combinations following data that is structured by columns that are labled, need help please!!

[Estatefinds]

DC

DD

DE

DF

DG

DH

DI

DJ

DK

DL

DM

DN

DD

DP

DQ

DR

DS

DT

DU

DV

DW

DX

DY

DZ

EA

EB

EC

ED

EE

EF

EG

EH

EI

EJ

EK

GC

GD

GE

GF

GG

GH

GI

GJ

GK

GL

GM

GN

GO

GP

GQ

GR

GS

GT

GU

GV

GW

GX

GY

GZ

HA

HB

HC

HD

HE

HF

HG

HH

HI

HJ

HK

instructions

are below

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

this data

A1

A2

A3

C4

C5

A6

C7

A9

A10

E11

E12

B13

D14

B15

A18

C22

E35

will change

>

B1

B2

B3

E4

E5

B6

D7

C9

E14

so macro

C1

C2

C3

D6

will work with data changes

D1

D2

D3

E1

E2

>

1

8

5

14

18

4

13

16

3

28

30

10

17

11

6

20

23

2

19

12

32

34

7

25

26

31

9

21

22

15

24

27

29

33

35

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

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

1-8-12-14-18

combos

combos

combos

combos

combos

etc>

1-8-12-14-34

1-8-12-14-15

1-8-12-14-25

1-8-12-14-16

1-8-12-14-26

1-8-12-14-28

1-8-12-14-30

1-8-12-14-17

1-8-12-14-31

1-8-22-25-26

1-8-22-25-28

1-8-22-25-30

1-8-22-25-31

1-8-29-32-34

1-8-29-30-31

1-8-14-18-25

1-8-14-18-26

1-8-14-18-28

1-8-14-18-30

1-8-14-1831

1-8-14-18-20

1-8-14-18-23

1-8-18-25-26

1-8-18-25-28

1-8-18-25-30

1-8-18-25-31

1-8-15-25-26

1-8-15-25-28

1-8-15-25-30

1-8-15-25-31

1-8-15-26-28

1-8-15-26-30

1-8-15-26-31

1-8-15-28-30

1-8-15-28-31

1-8-15-30-31

1-8-15-17-20

1-8-15-17-23

1-8-15-20-23

1-8-13-16-28

1-8-13-16-30

1-8-13-16-17

1-8-13-16-20

1-8-13-16-23

1-8-25-26-28

1-8-25-26-28

dont let the alpha numerics confuse you these are just for my use.

example shows how the numbers follow the rule presented below

these are just a hand ful of results but when the macro runs them all I would like them to be placed on the row 13 of worksheet in the range og GC to HK

the data in te column labled row 1

will continue until no other combinations can be made from left to right then it will go to the next number down in Row 1

which will the the number 2 it will do the same as above and continue untill there are no more combinations to be made left to right.

then it will go to the number and continue until no more combinations can be made left to right

then will go to 24 and continue until no more combinations can be made from left to right

then will continue to 33 and continue until no more combiantions can be made from left to right.

then the process will start over again but this time in the column labeled row 2.

so sonce the numbers in row 1 meaning the 1,2,9,24,33 are the starting point of the combinations the results will be placed in the column below the data lebeled row 1.

then the starting point will be at row 2 to start the process all over again,

the the first combinations will start witht eht first number 8 then it will find all combination in the data from lef to right once those are done it will go ot the next number 19 and continue until all combinations are found , then

it will go down to the next number 21 and continue to find all combnations until no more can be made. And so on.

then once all columns of data labeled rows are done where no more five number combinations can be made , from left to right as seen in the column labled row 1 the five number combinations.

added note: so look at the column labeled row 12 the numbers in this column are 30 this would look from this number to the right for the next number up in the columns to the right to build the combination.

So for example 30 is the first number and looks to the right for more numbers to build a combnation so 31 comes after 30 and there are no more numbers above 31 so a combination cant be made.

now once all the left to right combinations are done I need to have the macro run same idea but this time from right to left and place the combinations in the column labeled row in which the first number is used for example

the column labled row 35 has the number 23 so all the combination would go below that data in to the column labled 35. so from right to left it would start at number 23 and go to the next number in the column labled 14 and use the number 31 and then go to the column labled row and use the number 34

and go to column labled row 2 for the number 35 since there are only four numbers and not five numbers to make a five number combination this is not listed. Only five number combinations are listted. Then it would continue to look for combinations and once cant find any more it will go to the next number 20 in column lanbled row 22 and look for comboination from there and these combonations will be placed in column labled row 22.

so the results of the of the from right to left start in the same column and row label as the left to right just placed the right to left data under last data resulted from the lef to right data.

In column DC the number 1 is at the top of the data in which this will be the first number of a combination of five numbers smallest to great from left to right. So I need a macro to look at the first number

the number 1 for example and look at the columns to the right of the column labled row 1. the macro will then sart with the next number up in value whether it is one up or two or what ever until I has five numbers to make the combination, then it will start another combination doing the dsame thing as seen in the example in the column labeld row 1.

<colgroup><col span="5"><col><col><col span="112"></colgroup><tbody>
</tbody>

 

[shg]

Could you repost your question in a more readable format?

 

[Estatefinds]

the data in te column labled row 1

will continue until no other combinations can be made from left to right then it will go to the next number down in Row 1

which will the the number 2 it will do the same as above and continue untill there are no more combinations to be made left to right.

then it will go to the number and continue until no more combinations can be made left to right

then will go to 24 and continue until no more combinations can be made from left to right

then will continue to 33 and continue until no more combiantions can be made from left to right.

then the process will start over again but this time in the column labeled row 2.

so sonce the numbers in row 1 meaning the 1,2,9,24,33 are the starting point of the combinations the results will be placed in the column below the data lebeled row 1.

then the starting point will be at row 2 to start the process all over again,

the the first combinations will start witht eht first number 8 then it will find all combination in the data from lef to right once those are done it will go ot the next number 19 and continue until all combinations are found , then

it will go down to the next number 21 and continue to find all combnations until no more can be made. And so on.

then once all columns of data labeled rows are done where no more five number combinations can be made , from left to right as seen in the column labled row 1 the five number combinations.

added note: so look at the column labeled row 12 the numbers in this column are 30 this would look from this number to the right for the next number up in the columns to the right to build the combination.

So for example 30 is the first number and looks to the right for more numbers to build a combnation so 31 comes after 30 and there are no more numbers above 31 so a combination cant be made.

now once all the left to right combinations are done I need to have the macro run same idea but this time from right to left and place the combinations in the column labeled row in which the first number is used for example

the column labled row 35 has the number 23 so all the combination would go below that data in to the column labled 35. so from right to left it would start at number 23 and go to the next number in the column labled 14 and use the number 31 and then go to the column labled row and use the number 34

and go to column labled row 2 for the number 35 since there are only four numbers and not five numbers to make a five number combination this is not listed. Only five number combinations are listted. Then it would continue to look for combinations and once cant find any more it will go to the next number 20 in column lanbled row 22 and look for comboination from there and these combonations will be placed in column labled row 22.

so the results of the of the from right to left start in the same column and row label as the left to right just placed the right to left data under last data resulted from the lef to right data.

In column DC the number 1 is at the top of the data in which this will be the first number of a combination of five numbers smallest to great from left to right. So I need a macro to look at the first number

the number 1 for example and look at the columns to the right of the column labled row 1. the macro will then sart with the next number up in value whether it is one up or two or what ever until I has five numbers to make the combination, then it will start another combination doing the dsame thing as seen in the example in the column labeld row 1.

<tbody>
</tbody>

 

[Estatefinds]

one sec ill get a little better thank you

 

[Estatefinds]

DC

DD

DE

DF

DG

DH

DI

DJ

DK

DL

DM

DN

DD

DP

DQ

DR

DS

DT

DU

DV

DW

DX

DY

DZ

EA

EB

EC

ED

EE

EF

EG

EH

EI

EJ

EK

GC

GD

GE

GF

GG

GH

GI

GJ

GK

GL

GM

GN

GO

GP

GQ

GR

GS

GT

GU

GV

GW

GX

GY

GZ

HA

HB

HC

HD

HE

HF

HG

HH

HI

HJ

HK

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

C4

C5

A6

C7

A9

A10

E11

E12

B13

D14

B15

A18

C22

E35

B1

B2

B3

E4

E5

B6

D7

C9

E14

C1

C2

C3

D6

D1

D2

D3

E1

E2

1

8

5

14

18

4

13

16

3

28

30

10

17

11

6

20

23

2

19

12

32

34

7

25

26

31

9

21

22

15

24

27

29

33

35

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

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

1-8-12-14-18

1-8-12-14-34

1-8-12-14-15

1-8-12-14-25

1-8-12-14-16

1-8-12-14-26

1-8-12-14-28

1-8-12-14-30

1-8-12-14-17

1-8-12-14-31

1-8-22-25-26

1-8-22-25-28

1-8-22-25-30

1-8-22-25-31

1-8-29-32-34

1-8-29-30-31

1-8-14-18-25

1-8-14-18-26

1-8-14-18-28

1-8-14-18-30

1-8-14-1831

1-8-14-18-20

1-8-14-18-23

1-8-18-25-26

1-8-18-25-28

1-8-18-25-30

1-8-18-25-31

1-8-15-25-26

1-8-15-25-28

1-8-15-25-30

1-8-15-25-31

1-8-15-26-28

1-8-15-26-30

1-8-15-26-31

1-8-15-28-30

1-8-15-28-31

1-8-15-30-31

1-8-15-17-20

1-8-15-17-23

1-8-15-20-23

1-8-13-16-28

1-8-13-16-30

1-8-13-16-17

1-8-13-16-20

1-8-13-16-23

1-8-25-26-28

1-8-25-26-28

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

 

[shg]

I don't follow that at all, and can't find a question in your question. Maybe someone else can help.

 

[Estatefinds]

ok so its making combinations in order from row 1 and taking the numbers that are above the the number say number 1 and then looks to the data pool to the right and and tales the number that is closets to the number 1 as you can see in the list of combinations. if you look at the combinations one at a time you ll see the pattern of what i need the macro to do. let me know if you understand

 

[Estatefinds]

so i m trying to set up the data for analyzing

so its reading data starting from left to right and the number increases with every number added to the five number combination.
so for example out of a range of data 1,5,10,20,26,32,35 the fist combinations would be 1-5-10-20-26 reading from left to right.
another example 25,12,33,17,18,08 so for this one there would be no combination if i started with 25 ,33, there are no other numbers to build off of the 25 and it runs out of numbers keeping inn mind the number that make up the combinations are 1 through 35.

 

[Estatefinds]

so the combinations are always built off the first number. as in the first column labeled row 1.

 

[Estatefinds]

1	1																																			1
2	2																																			2
3										3																										3
4						4																														4
5			5																																	5
6																		6																		6
7						7																														7
8		8																																		8
9	9																																			9
10													10																							10
11															11																					11
12			12																																	12
13							13																													13
14				14																																14
15						15																														15
16									16																											16
17														17																						17
18					18																															18
19		19																																		19
20																						20														20
21		21																																		21
22			22																																	22
23																																			23	23
24	24																																			24
25							25																													25
26									26																											26
27		27																																		27
28											28																									28
29			29																																	29
30												30																								30
31														31																						31
32				32																																32
33	33																																			33
34					34																															34
35		35																																		35
	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
	so this should make it easier to understand for any one that can help me with a macro

<tbody>
</tbody>

so basically it is starting from the first top number in the data in row 1 and moving to the next row 2 and uses number that climbs higher an continues to do so to make a combination so my question is; Is there a macro that can perform this task?