Hello everyone,

I am new to excel completely and have just started a new job. I have been given an excel workbook and asked to organise it. The document looks like this (roughly):


Driver ¦ Date From ¦ Date To ¦ Time driving for ¦ Time rest for ¦

Dave 15/10/10 17/10/10 07:15 02:05
Mark 13/09/09 16/09/09 05:00 00:45

This is only sheet 1 i.e. CAR 1
There is 12 sheets all diffrent vehicles.

I have been told to organise it so I can search and display an Individuals work load i.e.:

Dave (CAR1) 15/10/10 17/10/10 07:15 02:05
Dave (Lorry 1) 14/10/09 16/10/09 08:10 05:12

Is this possible?? Help please