Was wondering if theres any macro programmers out here willing to make a few extra bucks.
Need:
a Lotto program on Microsoft excel with these features;
1. able to input 20 sets of 6 number draws.
2. able to put a name list of up to 500 names allowing them to place thier 6 numbers
3. if any of the numbers in any of the 6 number draws matches any of the names numbers, fill the space in with a color
4. when a name has matched all 6 of thier numbers announce a winner(s).
if anyone can do this or expand on an existing one let me know. I have one but has minimal name inputs and unable to combine 2 worksheets with the macros.
Quote from: touitsjesse on October 03, 2005, 11:53:03 PM
Was wondering if theres any macro programmers out here willing to make a few extra bucks.
Need:
a Lotto program on Microsoft excel with these features;
1. able to input 20 sets of 6 number draws.
2. able to put a name list of up to 500 names allowing them to place thier 6 numbers
3. if any of the numbers in any of the 6 number draws matches any of the names numbers, fill the space in with a color
4. when a name has matched all 6 of thier numbers announce a winner(s).
if anyone can do this or expand on an existing one let me know. I have one but has minimal name inputs and unable to combine 2 worksheets with the macros.
Its sounds very interesting and easy to program for anyone wanting to do this in Visual Basic C++. (yes I know you said Excel)
but to clarify..
1. you mean 20 sets of 6 numbers per each name?
...
4. does'nt some lotto games give wins (smaller payouts) at 4 or 5 placements out of possible 6?
This is a lotto pool....everyone is in for 10 bucks a piece and we keep playing every draw until sone gets all 6 of thier numbers filled., right now with 280 people in, it would rarely go more than 4 draws, BUT...i have seen these things go 10 + draws.
plus the reason, why i say excel, cause the fields are easily manipulated so one can alphabetize the list easily. If there anyone tries this and is able to just do a program, more power to them.