Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks m8, but i am struggling with this
Rgds Gordon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Database Query | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Links to External Database | Excel Discussion (Misc queries) | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) |