#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gordo
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gordo
 
Posts: n/a
Default Database

Thanks m8, but i am struggling with this

Rgds
Gordon

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Total Sales from a Database John Excel Worksheet Functions 0 November 3rd 05 12:26 PM
Database Query Neville Excel Discussion (Misc queries) 0 October 21st 05 05:54 AM
Database functions should use criteria in formula, as 1-2-3 does 123user Excel Worksheet Functions 8 September 29th 05 08:57 PM
Links to External Database Rubble Excel Discussion (Misc queries) 0 July 20th 05 10:44 PM
The Template Wizard retains the original location for my database Packwood Excel Discussion (Misc queries) 0 April 15th 05 05:25 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"