It seems suited to GillesD, but if anyone can point me in the right direction I'd be grateful!
Right, heres my problem! I have created different sheets in a workbook with different macros for each sheet producing varying results etc.. For example one sheet produces all lines! (Thanks GillesD!) Another sheet produces all lines within a sum range and so on!
Now, I would like to, for example, eliminate the ACTUAL LINES DRAWN from the one with all possible lines. Can anybody tell me the notation or provide an example macro that would read the contents of another sheet?
I know you've all probably tried this or are doing this but what I'm after is producing all lines (in one sheet, DONE), eliminating lines drawn, eliminating certain sum ranges, eliminating Hi-Lo & Od-Ev ratios that don't meet my criteria, eliminating lines with more than 2 prime numbers, eliminating any lines that DON'T have a number from the previous draw, eliminating lines with 3 or more consecutive numbers, eliminating lines with more than 1 set of consecutive numbers i.e. 1,2,16,19,30,49 is OK but 1,2,16,19,20,49 isn't,
eliminating lines where numbers are out of positional play WITH ALL RESULTS for each method in its own sheet!
This is more of a personal experiment than for actually playing, though I will post results and macros, if requested!, for people to use for their own means.
I actually have a Lotto program that does a lot of this for me, but I want to extend the functionality to do more by using excel!
Thanks In Advance! All comments (even other methods used) appreciated!
Right, heres my problem! I have created different sheets in a workbook with different macros for each sheet producing varying results etc.. For example one sheet produces all lines! (Thanks GillesD!) Another sheet produces all lines within a sum range and so on!
Now, I would like to, for example, eliminate the ACTUAL LINES DRAWN from the one with all possible lines. Can anybody tell me the notation or provide an example macro that would read the contents of another sheet?
I know you've all probably tried this or are doing this but what I'm after is producing all lines (in one sheet, DONE), eliminating lines drawn, eliminating certain sum ranges, eliminating Hi-Lo & Od-Ev ratios that don't meet my criteria, eliminating lines with more than 2 prime numbers, eliminating any lines that DON'T have a number from the previous draw, eliminating lines with 3 or more consecutive numbers, eliminating lines with more than 1 set of consecutive numbers i.e. 1,2,16,19,30,49 is OK but 1,2,16,19,20,49 isn't,
eliminating lines where numbers are out of positional play WITH ALL RESULTS for each method in its own sheet!
This is more of a personal experiment than for actually playing, though I will post results and macros, if requested!, for people to use for their own means.
I actually have a Lotto program that does a lot of this for me, but I want to extend the functionality to do more by using excel!
Thanks In Advance! All comments (even other methods used) appreciated!