|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.