Have you looked at the possibility of using a pivot table? In essence this
gathers required information into a table. Have a look at <Data<Pivot
table and pivot chart report ...

Basically you drag the headings into the relative parts of the report.
However, in practice you may need to have a few goes before getting it just
right.

Regards.

Bill Ridgeway
Computer Solutions

"kevhatch" wrote in message
...
Hi,
I have a worksheet that I enter details of worksheets handed in by
employees
i.e. in col1 name, in col2 date and in col3 if worksheets not handed in I
enter L,H or S (Late,Holiday or Sick).

What I am after is to list the names of employees on a new sheet if they
have L,H or S against their name and also to show against their name the
reason (Late,Holiday or Sick rather than L,H or S).
Hope this makes sense.
Thx in advance
Kev