In need of help with a database

[g6773a]

Hey y'all. I have a problem that I do not know how to solve. I am a basic excel user whose supervisor has laid a requirement on him above his skill level. I am working in 2003.

Here's what I need help with. I have a database in which I track which employees fill out paperwork on company trucks. There are 15 trucks and 20 employees. The database works fine, and with the use of a couple of filters, I can easily tell who isn't filling out there paper work. Now my boss wants it set up so that the database tells him which employees haven't filled out the paperwork and which trucks haven't had paperwork turned in for them. Apparently auto-filters are to complicated for him. Have I lost you yet?

I do not have a copy of my workbook on this PC, but I can explain it fairly easy. Sheet 1 is a data entry sheet. It has validation lists for all drivers and trucks. All I have to do is enter the pick the driver's name and a truck number out of a drop down list. I click a button and it is all copied and saved in a database. Sheet 2 is the database itself, where the info can be sorted by date, driver, and truck number. How can I generate a database that shows which drivers and which trucks have NOT had paperwork turned in ?

 

[Marcelo Branco]

Hi,

Welcome to the forum.

Could you post a sample of your database?

To do this
Select a relevant part of your data, say, 10/15 rows including headers, put borders, copy (Ctrl+C), and paste in the forum reply-page.

M.

 

[g6773a]

Excel Workbook
	A	B	C	D
1	Industrial Powered Truck Checklist Database
2	Date	Lift Number	Hours	Operator
3
4
5	08/18/11	576		kevin w
6	08/17/11	576		Jose S
7	08/17/11	592		kevin r
8	08/16/11	565		david
9	08/16/11	560	20,094	bobby
10	08/16/11	597		john
11	08/16/11	596		lupe
12	08/16/11	503		rodolfo
13	08/16/11	572		rodolfo
14	08/16/11	581		Joseph
15	08/15/11	597		john
16	08/15/11	596		lupe
17	08/15/11	592		arthur
18	08/15/11	581		joseph
19	08/15/11	560		rodolfo
20	08/15/11	572		rodolfo
21	08/15/11	503		otis
22	08/15/11	287	13,782	nate
23	08/12/11	576		Asuncion (Ruiz)
DATABASE

 

[Marcelo Branco]

Hi,

Considering your data-sample what are the expected results?

M.

 

[g6773a]

Hi,

Considering your data-sample what are the expected results?

M.

Lets see if I can explain this better. I am currently generating a list of who submitted paperwork. Is there some way (conditional formatting,Vlookup, Macro...) that I can generate a list of who did not submit paperwork?

 

[Aladin Akyurek]

Lets see if I can explain this better. I am currently generating a list of who submitted paperwork. Is there some way (conditional formatting,Vlookup, Macro...) that I can generate a list of who did not submit paperwork?

How does one conclude from the sample you posted to "who did not submit paperwork"?

 

[g6773a]

All vehicles and drivers are listed in validation lists

 

[Aladin Akyurek]

All vehicles and drivers are listed in validation lists

Still unclear. What is the desired outcome, given the sample youposted?