Finding Certain Data in a Worksheet

A

Airfive

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

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Find Specific Rows in Range and Create New Tab 18
Macro to Insert Worksheet with Worksheet Name the Current Date 1
Summarize information on different sheets of the workbook 1
2 finds/findnext in nested loops 1
How to add additional worksheets to a directory of workbooks 1
Linking data from one worksheet to another using ookup functions 2
Exporting Data from MS-Access to Excel 2

Top