Finding and collating data

Hi
At work we use a basic spreadsheet to record attendance of employees. Employee names are across the columns, two columns per employee to denote half shifts. Dates are on the rows with each date in row B. What I would like to do is link the data into a separate worksheet (I've done this bit), then look for all occurences of holidays, represented by the value 5, for each employee. Using this I want to create a table that shows the holiday dates that each employee has taken.

Is it possible to do this, I've had a look at the VLOOKUP and HLOOKUP functions but I can't see how to make these do what I want.

Thanks in advance

Hi
Thanks for the welcome and quick reply.
I have tried to create a pivot table but all I can get is a count of the number of holidays taken, while this would be fairly useful I would rather be able to see all the holiday dates taken, if that's possible.

Thanks

Hi Portuga

Thanks for the offer, I've attached a single sheet from the workbook, each shift is on a separate sheet and there also graphs etc on other sheets. I'm wondering if the poor formatting of the sheet is causing problems? Unfortunately I am unable to change this as the same spreadsheet is used throughout the company.

Thanks in advance.

Hi Portuga

Thanks for looking at the sheet. I can see what you have done but it isn't what I was looking for, I wanted the actual dates of each employees holidays to be shown. i.e.

Employee 1 01/03/08 02/03/08 24/08/08...
Employee 2 10/04/08 11/04/08 12/04/08... etc.

Sorry, I should have explained it a little better in my original post.

Thanks