Pick 3 Excel Program
Hi Pab,
I'm trying to create a chart of Alpha Patterns using Pick 3 draws.
I have 2 Excel files
The 1st Excel file called P3Draws. This is where I update the New York Pick 3 draws.
The 2nd Excel file called Pairs1State. This is where I transfer all the draws from the 1st Excel file P3Draws into this Excel file Pairs1State and perform the calculations.
This is what I would like to do if possible:
1. Take 100 draws at a time from the Excel file P3Draws starting at line 1082, Wednesday Evening June 14, 2006 to Wednesday Midday April 26, 2006.
2. Copy and paste these 100 draws into the Excel file Pairs1State Tab P3Draws on cell A20:E119
3. Next, go to the Pairs1State Tab labeled "AlphaPatterns" and click the Toolbar labeled "Click To Add Line" (Cell A14&A15). This will add a new line and enter the new Alpha Patterns. I already added 3 draws with the Alpha Patterns as an example. Instead of doing it line by line I would like to automate this routine.
4. Next, click the (BIG) Toolbar labeled "Click To Sort & Rank Digits & VTRAC Digits. This will sort all the digits and VTRAC digits in skip sequence.
5. Next, start the cycle over again starting with Step 1. But this time use another 100 draws starting with Thursday Midday June 15, 2006 through Wednesday Evening April 26, 2006.
Keep this same cycle until it finishes the last entry on line 20, Wednesday November 28, 2007.
Here is a link to the files:
http://www.badongo.com/file/5384760
