R
Rosco
I am trying to get away from hand written paperwork at work, it
looks messy and when there is an accounting mistake, it is sometimes
too dificult to read someones handwriting. Therefore I am converting
everything over to spreadsheets and simplifiying as much as possible
for the person entering data. I am having trouble with one sheet
though, help would be greatly appreciated.
Please refer to the following two images for reference
http://webpages.charter.net/rosco111/Log.JPG
http://webpages.charter.net/rosco111/DB.JPG
The first link is the daily paperwork and the second will only be
edited when a new scratch off game is released. It should be used
for reference by the first
On the first sheet when the user enters the three digit game number
into collum A , the second sheet should be checked and then the
appropriate fields filled out on the first
Example: The first line is game 603, the game is named Test Game 1
which was pulled from B2 on the database the ticket value is 5.00
pulled from B3 on the database, the QTY is 75 pulled from B4 and so
fourth.
The dates and pack numbers will vary greatly so they will be user
defined. Please help, I just need to know how to get LOG to pull
information from Database based on the game number
looks messy and when there is an accounting mistake, it is sometimes
too dificult to read someones handwriting. Therefore I am converting
everything over to spreadsheets and simplifiying as much as possible
for the person entering data. I am having trouble with one sheet
though, help would be greatly appreciated.
Please refer to the following two images for reference
http://webpages.charter.net/rosco111/Log.JPG
http://webpages.charter.net/rosco111/DB.JPG
The first link is the daily paperwork and the second will only be
edited when a new scratch off game is released. It should be used
for reference by the first
On the first sheet when the user enters the three digit game number
into collum A , the second sheet should be checked and then the
appropriate fields filled out on the first
Example: The first line is game 603, the game is named Test Game 1
which was pulled from B2 on the database the ticket value is 5.00
pulled from B3 on the database, the QTY is 75 pulled from B4 and so
fourth.
The dates and pack numbers will vary greatly so they will be user
defined. Please help, I just need to know how to get LOG to pull
information from Database based on the game number