Subtotalling-inserts a new blank row

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

After running the subtotal operation, turn on autofilters and select blanks
in the Employee Number column. In the first visible row, enter a formula to
copy the value from the cell above (ex: the Empl# column is C; first
visible (subtotal) row is 5. In c5 enter =c4). Autofill the formula into
the other visible rows.
Turn off the filters (or just Show All) and you should be set.
--Bruce

"MarkN" wrote:

> 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

Thanks Bruce,

This has saved me so much time
--
Thanks again,
MarkN


"bpeltzer" wrote:

> After running the subtotal operation, turn on autofilters and select blanks
> in the Employee Number column. In the first visible row, enter a formula to
> copy the value from the cell above (ex: the Empl# column is C; first
> visible (subtotal) row is 5. In c5 enter =c4). Autofill the formula into
> the other visible rows.
> Turn off the filters (or just Show All) and you should be set.
> --Bruce
>
> "MarkN" wrote:
>
> > 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