Finding Certain Data in a Worksheet
 

Hello all,

I have a worksheet that I use as a timesheet. I have been asked to go back a
year or so and retreive data from these timesheets for a particular job. I
was wondering if there is a way for excel to search through the timesheet and
return only the data I need for that particular job. For instance, column A
has employees names. Column B has the Truck # they drove that day. Columns
J through Z contain the job numbers they were assigned to on a particular
day. I need to search through the timesheet and return only the employees who
worked on job "1139", and the truck they drove that day. Does this seem
possible in excel. Any replies are greatly appreciated. Thanks

Finding Certain Data in a Worksheet
 

have you tried datafilterautofilter

--
Don Guillett
SalesAid Software

"Airfive" wrote in message
...
Hello all,

I have a worksheet that I use as a timesheet. I have been asked to go back
a
year or so and retreive data from these timesheets for a particular job.
I
was wondering if there is a way for excel to search through the timesheet
and
return only the data I need for that particular job. For instance, column
A
has employees names. Column B has the Truck # they drove that day.
Columns
J through Z contain the job numbers they were assigned to on a particular
day. I need to search through the timesheet and return only the employees
who
worked on job "1139", and the truck they drove that day. Does this seem
possible in excel. Any replies are greatly appreciated. Thanks