create a list by name and date from another page

[JasonH]

I have attached an example of the spreadsheet I am working with.

the page labeled scores has the scores in blocks arranged by agent and date .

what I am looking for is something that can put all of the scores in a list (on the page labeled list) first by agent name, then by date.

I typed in an example of what the end result should look like. problem is i have over 100 agents to work with and i really don't want to type all that in.

any ideas that don't involve a macro?

[Richard Buttrey]

I have attached an example of the spreadsheet I am working with.

the page labeled scores has the scores in blocks arranged by agent and date .

what I am looking for is something that can put all of the scores in a list (on the page labeled list) first by agent name, then by date.

I typed in an example of what the end result should look like. problem is i have over 100 agents to work with and i really don't want to type all that in.

any ideas that don't involve a macro?

I can't see any solution that doesn't involve a macro. The data is not laid out consistently enough to be able to treat it as a series of tables, and use filters or even sumproduct() functions to analyse them.

You could do a lot more cutting and pasting, and adding agents and supervisors names to each row, and then stack the agents' blocks underneath each other so that you end up with a big table which could be analysed with functions() and/or filters etc., but by the time you've done that you might as well write a macro to do it.

Rgds