Try a pivot table (PT) .. it's great for this kind of task .. 10 seconds only
<g

Steps below in xl2003 (but should be similar for earlier ver):
First, enter a label for col A, eg: Staff
Select any cell within the table, click Data Pivot table & PivotChart
Report
Click Next Next. In step 3, click Layout, drag n drop Staff in the ROW
area. Drag n drop Task 1 in DATA area. Repeat the drag n drop for Task
2,3,4,...Total (Drop each below the previous). Click OK Finish. The PT will
be created in a new sheet to the left. Go to the PT sheet, then just drag the
col header "Data" and drop it over "Total", and the resulting table will be
exactly what you want (do-able within 10-15 secs flat <g).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Janev" wrote:
Can anyone help please?

I have a table of staff members and tasks set out as follows (the real
one is a lot bigger)

Task 1 Task 2 Task 3 Task 4 Total
Staff member 1 1 2 3 1 7
Staff member 1 2 4 1 5 12
Staff member 3 1 3 5 4 13
Staff member 4 1 2 4 2 9
staff member 4 3 1 2 4 10
Staff member 5 1 3 3 5 12
Staff member 6 4 4 1 1 10
Staff member 6 3 2 3 2 10



I would like this table to end up with just one entry for each person
and their tasks added up

So that for instance for staff member 1,



Task 1 Task 2 Task 3 Task 4 Total
Staff member 1 3 6 4 6 19

and so on.


Can anyone help with a macro thanks?

Janev