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 / collate all the entries for one person onto 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
Bookmarks