How dare you call my macros dodgy <bg

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Janev" wrote in message
...
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).