Hi I have a free lottery spreadsheet I previously downloaded. The original source webpage information is included in the zip file.
I'd like to customize this lottery spreadsheet to tally number combination pairs, starting from the previous week's 1st number & successively matching it up with all the winning numbers drawn next week (rather than just matching pairs in the same drawing/row)
Modelled off the main spreadsheet by keeping its macro formatting which is excellent, but have the first number (of the matched pair) being from week 1 and the second number being from week 2 then successively match all week 1's first number to all 6 of week 2's numbers. And then go the second number drawn in week 1 and repeat through all 6 of week 2's numbers etc.
eg week 1 numbers: 3,5,14,22,30,44 week 2 numbers: 6,12,15,16,31,44 in the pairs sheet it would start matching up pairs 3,6 3,12 3,15 ...3,44 then 5,6 5,12 5,15 ...5,44 etc all the way to 44,6 44,12 44,15 ...44,44 (therefore the same number can pair up with itself (eg 44,44) as it's spread accross 2 weeks. And the bottom half of the matrix would also be used rather than blank)
It probably needs the code modified or a new macro recorded to do the above request. The original webpage has instructions on the source macro and vba code.
If the above can be achieved with the sample 20 rows of data in the spreadsheet, I'd like to at a later date paste lot's more rows of data than just 20 in the original file. In the original file, I pasted in extra rows of data, and the macro seemed to handle the request and tallied all the numbers. Also the ability to add more than 6 balls.