Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 07-09-2009, 11:11 PM
nmhs2 nmhs2 is offline
Registered User
 
Join Date: 09 Jul 2009
Location: US
MS Office Version:Excel 2007
Posts: 2
nmhs2 is becoming part of the community
Post Help with macro new to this (lottery sales)

Please Register to Remove these Ads

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
Reply With Quote
  #2  
Old 07-10-2009, 12:02 AM
nmhs2 nmhs2 is offline
Registered User
 
Join Date: 09 Jul 2009
Location: US
MS Office Version:Excel 2007
Posts: 2
nmhs2 is becoming part of the community
Re: Help with macro new to this (lottery sales)

bump bump bump
Reply With Quote
  #3  
Old 07-10-2009, 12:42 AM
shg's Avatar
shg shg is online now
Forum Guru
 
Join Date: 21 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 17,881
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Re: Help with macro new to this (lottery sales)

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote


Reply

Bookmarks

Tags
start end numbers


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump