Macro to return rows with subtotals and ditch other data
Posted by Dwight on March 20, 2001 6:38 AM
I need a macro that will consolidate rows containing same text in column A into single rows showing the subtotals in column B. For instance:
Column A Column B
Row 1 Acme $1,000
Row 2 Apex $2,000
Row 3 Acme $4,000
would convert to
Column A Column B
Row 1 Acme $5,000
Row 2 Apex $2,000
Any help would be appreciated.
Posted by SJC on March 20, 2001 11:09 AM
Try using a pivot table with the field name of column A in the Row section and the field name of column B in the Data section (be sure to use sum).
