Thread: Help with macro new to this (lottery sales)

Hey guys I have recently been selling the lottery and I need to come up with a system to keep track of my sales. The way I do this is i take the start number of every ticket and put them in one column then put the end ticket number in another column then have a function calculate the difference in tickets to see how many i sold. Instead of copying the end ticket # into the start ticket # everyday how can I do this automatically. I need to have the end ticket number automatically move into the start ticket number the beginning of each day automatically so no one can fool around with the numbers. Help would be appreciated im new to this

bump bump bump