What you want is to create a PivotTable report. Try this to get started:
http://office.microsoft.com/training...RC010136191033

Have fun. :)

"Jebaneesa" wrote in message
...
I currently have a Data sheet which contains the columns "Payrol, Team,
Agent
Name, Calls Answered, Talktime, Logged in Time & Not Ready Time" for every
day of the month on a seperate worksheet, I would like to add a front
sheet
with drop downs that managers can select the team name and date. This
would
then only populate this sheet with details of the selected team on the
selected day. I have tried INDEXMATCH but not sure about this function and
how to collect all the agents for the given team. I need to keep the
workbook
as small as possible to publish on the web.

Any help greatly appreciated