why use code at all?

change your formula to accept input from a cell
then put a datavalidation with lookup on that cell
to show the employee names.

since the employeenames are not on the same sheet
you must define a (global) name for the employee list
before creating the datavalidation.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


alymcmorland wrote :


Hi,

i have a table as shown in the attached picture. Its a registeration
database built in excel.

Is it possible to have a report on a seperate spreadsheet which when
the user puts in a name it'll match to the name on this spreadsheet
and return the dates for when an employee is off sick or on holiday
or late and so on.

So say i wanted to know mr x's sick days, it would have to find his
sick boxes, (which are red with an S) under his name and return the
values in the first column which is the dates.

Is this possible?

So far i have this code which will look up the amount of times someone
is off sick or whichever: