I keep a spread sheet running that has dates along the top for each month and
names of staff down the side, if they take a holiday or are sick we enter "H"
or "S"
What i would like to have is a summery sheet that will list actual days
taken as sick or Holiday. So i assume maybe some sort of Lookup at looks for
the Letter H or S and then checks the date and then the name and returns a
date.
Is this possible?

Many thanks in advance for any help