Pulling related data to additional sheets in a workbook

I have a spreadsheet which our department uses to track staff leave. On the vertical axis we have staff names, and on the horizontal axis are the days of the year. We use letters in the grid which depict what type of leave people take on each day ie 'R 'for rec leave and 'A' for accrued days off etc.

What I need to do is pull that data into a report on another worksheet day by day which shows the days of the week and lists who is on rec leave or study leave etc. It sounds odd but the director is a pain and insists on this for rostering.

For example, I need to list the names of staff members who may be on recreation leave on the 14th July.

Any ideas?

The sheet can be found here http://dl.dropbox.com/u/496838/2010%...ar%20Leave.xls

1) Can you EDIT your original post, GO ADVANCED, and put a more appropriate title on this thread, as per the Forum Rules? Thanks.

2) Can you point to a specific sheet and specific cell as an example of the results desired so we know where to look, it's not obvious on your sample sheet, even with the titled sheets. (Not obvious to me, at least)


NOTE: you can click GO ADVANCED and use the paperclip icon to attach workbooks to your post instead of uploading elsewhere, just a tip.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.