Hello all,

Please note that I have ben asked to create a spreadsheet that will generate a report for staff working in a call centre. The basic form is as follows:

Worksheet 1
User Calls Trigger
Staff1 Total Trigger field
Staff2 Total Trigger field

Worksheet 2
User Calls Trigger
Staff1 Call1 123
Staff1 Call2
Staff2 Call1 123
Staff2 Call2 123
Staff2 Call3 123

The required design is for 13 worksheets in this spreadsheet with WS1 being used to display the results for each month but worksheets 2 - 13 being used for the call data for that month. There can be tens of thousands of calls each month with the possibility of several thousand per person.

I need to be able to work out how to do two things with this spreadsheet. The first is to count how many calls each member of staff has logged and how many of these calls have the trigger field completed (there is no need to verify the contents of the trigger firld as that has already been done). There should only ever be 1 row per member of staff on WS1 so this worksheet will always be a lot shorter than the other worksheets.

Thanks in advance all.

M.