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>