On Mon, 4 Sep 2006 02:54:01 -0700, Max wrote:


Thanks Max, that is briliiant, would have saved me hours of work today
trying to get dodgy macros to work.

Jan.
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).