Hi I would be grateful if someone could help me with this problem please...

I cuurently have a workbook with the sheets designed as a diary (each sheet being one date.

On each row of a partiuclar sheet i enter different jobs under various headings in the columns

One of the columns is for a persons payroll number and is unique to that person.

What i am trying to do is to group all the entries for one person on to another worksheet so at the end of the month it will show all the jobs that person has done for the month.

I have tried (very unsuccesfully!!) to do this myself so would really appriciate some advice or help from the Experts out there.

If the explanation of what i am trying to do is not clear, please feel free to contact me.

Many thanks

Paul