Finding Certain Data in a Worksheet

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Insert Worksheet with Worksheet Name the Current Date 1
Produce a workbook for each employees data in a worksheet 3
Find multiple values 1
Can this be done in Excel 1
How to add additional worksheets to a directory of workbooks 1
Increasing date in link 7
Save as PDF not working on a domained Windows 7/Vista box 2
Help on Which Way to go ?? 1

Top