This is a simple example of my problem. I have a sheet that has three columns
(Name, EmployeeNumber and Amount). Each month a raw dump is produced where
each name occurs many times. I am interested in seeing the total Amounts for
each person so I sort by the name and subtotal the list.

Subtotalling inserts a new blank row and places the subtotalled value along
this row. Is there a way of filling this blank row with the Name and
EmployeeNumber as well as the subtotalled amount.

Any help very much appreciated.
--
Thanks,
MarkN