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

Have fun.

"Jebaneesa" <Jebaneesa@discussions.microsoft.com> wrote in message
news:08C79273-E460-40FC-828B-7B5C5B5BAD31@microsoft.com...
>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