Additonal info into newly created Subtotal row

[BigDogR]

How might I carryover/copy additional information into the newly created row
that includes the subtotal and name of the subtotal? For instance, the
product number (Column A) is what is grouped to determine the subtotal of the
Sales for that product group (Column C) but I want to include the item
description which is in Column B of the rows above. I have 35,000 rows of
data being subtotaled and want to avoid cutting and pasting this information.
Then, I plan to sort the subtotal data from highest to lowest and would like
to have the description in the printout of the subtotals (with the details
hidden).

 

[Glenn]

How might I carryover/copy additional information into the newly created row
that includes the subtotal and name of the subtotal? For instance, the
product number (Column A) is what is grouped to determine the subtotal of the
Sales for that product group (Column C) but I want to include the item
description which is in Column B of the rows above. I have 35,000 rows of
data being subtotaled and want to avoid cutting and pasting this information.
Then, I plan to sort the subtotal data from highest to lowest and would like
to have the description in the printout of the subtotals (with the details
hidden).

First, you might consider a PivotTable instead of Subtotals. If you are not
familiar with them, look here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Otherwise, collapse your data to include only the Subtotals. Select the first
blank cell in column B. Assume that cell is B14. In that cell, enter the
following formula:

=B13

Copy that cell. Select the rest of the empty cells currently showing in column
B. Edit / Go To / Special / Blanks / OK. Paste. Re-calculate (if not
automatic). Now show all of your data. Select Column B. Copy. Edit / Paste
Special / Values / OK.