![]() |
Database
Hi,
I wonder if someone can help me regarding the below... I want to set up a database where the front spreadsheet shows names in a drop down list and in a sepearte list the times of each shift. In the third column i want to key enter number of cartons. Once this is done the user presses next record and this information is stored on the database. At the end of the shift the information that has been entered can be printed out for viewing. I am not sure if the above is possible using excel but this is all i have to work with at work Please, Please advise Rgds Gordon |
Database
gordo Wrote: Hi, I wonder if someone can help me regarding the below... I want to set up a database where the front spreadsheet shows names in a drop down list and in a sepearte list the times of each shift. In the third column i want to key enter number of cartons. Once this is done the user presses next record and this information is stored on the database. At the end of the shift the information that has been entered can be printed out for viewing. I am not sure if the above is possible using excel but this is all i have to work with at work Please, Please advise Rgds Gordon Check this out! download the example sheet, you may be able to start with this and this customize for your own use. http://www.contextures.com/xlDataVal13.html -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=516677 |
Database
Thanks m8, but i am struggling with this
Rgds Gordon |
All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com