I have a spreadsheet which subtotals several cells using the subtotal menu
function. As you can see below the cells I am using. I would like it to also
insert the cell that has the HD4715 in with the totals line. Is there a way
to do this rather than have to go through a lot of copying and pasting. After
I subtotal I usual hide the detail rows. Any help would be appreciated.

Richard

Abitia, Monica B Abitia Monica 1/29/2007 HD4715 7.5
Abitia, Monica B Abitia Monica 1/30/2007 HD4715 7.5
Abitia, Monica B Abitia Monica 1/31/2007 HD4715 7.75
Abitia, Monica B Abitia Monica 2/1/2007 HD4715 7.75
Abitia, Monica B Abitia Monica 2/2/2007 HD4715 8
Abitia, Monica B Total 38.5