creating a table to show resources >25% availability in given week

Hi

i have been asked to create something that will use the first sheets availability section (a24 - a33), and show how many resources have >25% availability, which is anything 9 hours or over, and then show each resource by week.

this will display in the sheet 'availability' in a table form, where you can select a given week and see each resource that is over 9 hours in availability.

(this is a dummy workbook, the actual one is much much larger and contains 3 locations and 3 availability areas, but if i was to get a solution here i could translate it to each)

i do not know the best way to go about this, i think the best way would be a drop down with each week on it, and when the week is selected it displays each resource name and the hours (over 9) for that person, in a small table.

what do people think? i wouldnt know how to go about grabbing the specific data, and names from the sheet and placing them in a table in the next sheet.

any ideas, i hope i have explained this well enough, feel free to ask me any questions, it is one of those tasks you are given by someone higher up who thinks everythings easy in excel and doesnt know how complicated a simple task can be.

hope you can help

Neill

no, i wanted a table or some type of report to grab the data from that area, so that you could look by week and see which resource was .>=9 hours in availability, on the seperate sheet... this is just a small workbook that is like the huge sheet i will be working from, with different areas for availability for a few different sites, so autofiltering would not work on the bigger sheet, i was hoping you could use a table on the other sheet and select the week where you could see the data.. i.e which resources are >= 9 for the selected week.

let me try and explain
i need to use the data from area A24:T33 on the sheet 'Belfast Hours', and create a table/report or something on the sheet 'Availability' that uses the data from the first sheet, and has a function where you can view by week that will show you a list of any resources who has an entry of over or equal to 9 hours for that week..