View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Airfive Airfive is offline
external usenet poster
 
Posts: 12
Default 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