Excel Keno/Lottery Data Analyser

What i need is a formula/s (VBA &/or macros on separate sheets) to display how many times a combination set of numbers has occurred from a data set. Starting from 1 to 8,145,060 (6 from 45) combination's and then to check each line to the drawn numbers (data set) to find out hot/cold atm sets. I know how to use the filters so im ok there (to sort out what i want) , and yes i know keno is an 80 number game, but I just ignore the last 35 numbers to give me better odds. What i have so far : I'm currently using Excel 2007 Each Sheet ( 1 to 9 ) has 1,000,000 combinations (please see pic below) ** ignore Column H for the moment its not what i need ** [IMG][login to view URL][/IMG] And Sheet 10 has the Draw History ( data set ) please see pic below ** Currently it has 16,000 draws (2 months worth) i will MAX it out at 20,000. [IMG][login to view URL][/IMG] So This is what i require : 1. I need column H on each of the nine sheets to display how many times (Total) , 4 of the numbers in that lines combination have occurred from the data set in sheet 10. 2. I need column I on each of the nine sheets to display how many times (Total) , 5 of the numbers in that lines combination have occurred from the data set in sheet 10. 3. I need column J on each of the nine sheets to display how many times (Total) , 6 of the numbers in that lines combination have occurred from the data set in sheet 10. 4. I need column K on each of the nine sheets to display the draws where 6 of the numbers in that lines combination have occurred from the data set in sheet 10. 5. I need column L on each of the nine sheets to display the draws average distance where 6 of the numbers in that lines combination have occurred from the data set in sheet 10. ( calculated from column K ) 6. I need column M on each of the nine sheets to display the last draw where 6 of the numbers in that lines combination have occurred from the data set in sheet 10. 7. I will need to be able to change the data set on sheet 10 whenever i want (max 20,000 draws) 8. Draw Number on sheet 10 will be sequential 1 to max 20,000 9. I will need to be able to use filters to sort data on columns H to M. 10 . I would like to keep the workbook layout as is, from provided book, extra sheets with additional VBA scripts etc is no problem , as im not worried about the MB size of the final workbook. 11. Needs to work in Excel 2007. Please find my .xlsx uploaded here as a starting point (151mb .rar) : [login to view URL] Example of what the sheets should look like: [IMG][login to view URL][/IMG] Budget: Project with exactly what i need $30 Project with exactly what i need + some nice professional visual basic presentation sheets of data that i can print $50 Additional services may be required later as a separate project in the future. Time Frame: 1 to 2 Weeks or ASAP Thank you for viewing.