ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Database (https://www.excelbanter.com/excel-worksheet-functions/74011-database.html)

gordo

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


davesexcel

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


gordo

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