Bob,

Thought it was a super sub, notwithstanding Janev's preference for the
pivot-table approach <bg. Tested the sub with the data as posted. The sub
ended up with the desired results, but it apparently distinguished the case
for "Staff member 4", viz there were 2 lines:

Staff member 4 1 2 4 2 9
staff member 4 3 1 2 4 10

Strangely, the pivot table doesn't have this case sensitivity issue, it gives:
Staff member 4 4 3 6 6 19

Is there a way to have your sub ignore the case and produce the same result
as the pivot table? Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---