Welcome Guest
Log In | Register )
You last visited January 21, 2017, 12:28 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 4 - Excel Sheets!

Topic closed. 16 replies. Last post 8 years ago by diamondpalace.

Page 2 of 2
PrintE-mailLink
diamondpalace's avatar - Untitled 2.jpg
Dallas, TX
United States
Member #60284
April 12, 2008
3856 Posts
Offline
Posted: February 2, 2009, 11:32 pm - IP Logged

thanks for sharing

You're welcome msmusic.

    diamondpalace's avatar - Untitled 2.jpg
    Dallas, TX
    United States
    Member #60284
    April 12, 2008
    3856 Posts
    Offline
    Posted: February 2, 2009, 11:37 pm - IP Logged

    I am trying to combined midday and evening into one sheet and the problem I am having is the  pick-4 # how do you get the right ones I deleted this colum and even when you change states on the excel sheets how do you get this colum.

    To combined both mid and eve results into one, simply download the sheet and give it a different name. Don't delete anything, but replace the numbers with the new numbers you want to record. In this case mid numbers and evening numbers.

    So your format should be like this for both mid & eve:

    1/29/09 mid    0-1-2-3
    1/29/09 eve    1-2-3-4
    1/30/09 mid    5-6-7-8
    1/30/09 eve    9-0-1-2

    You're adding to the list, don't delete or insert new colums/row that will mess up the code, which is needed to automate everything else.

    The oldest result goes on top, newest at the bottom. Hope this helps.