ExcelBanter - How do I get subtotal line to display other column?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get subtotal line to display other column? (https://www.excelbanter.com/excel-discussion-misc-queries/143246-how-do-i-get-subtotal-line-display-other-column.html)

basic

How do I get subtotal line to display other column?

Excel 2002

I am using subtotal on column A, but need column B to also displayed .

Example:
A B C
Mach. Part Good
01 F3LP 150
01 F3LP 150
---------------------------------------------
01 TOTAL 300

*************************************
Would like it to display as follows:
---------------------------------------------
01 TOTAL F3LP 300

All times are GMT +1. The time now is 11:24 PM.