Pick 4 - Excel Sheets!Prev TopicNext Topic

• diamondpalace

  

  United States
  Member #60,282
  April 12, 2008
  3,857 Posts
  Offline
  Feb 2, 2009, 11:32 pm

  ▲▼
  In response to msmusic

  Quote: Originally posted by msmusic on Feb 2, 2009

  thanks for sharing

  You're welcome msmusic.
• diamondpalace

  

  United States
  Member #60,282
  April 12, 2008
  3,857 Posts
  Offline
  Feb 2, 2009, 11:37 pm

  ▲▼
  In response to merdis salley

  Quote: Originally posted by merdis salley on Feb 2, 2009

  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.