SUBTOTALS
 

TAKE A LOOK AT THE FOLLOWING DATA. Is there a way to create a macro or a one
button solution to create the following subtotal line. Currently this is a
manual process, and I know we can do it via the sigma function, however I'm
looking for a quicker/automated solution. One that creates "Subtotal
Description" and Subtotals the gross profit and gives me the % profit.

QTY DESCRIPTION Price Each Price Total Cost per Gross Profit % PROFIT
5 6X6 TEE L/A $54.40 $272.00 $48.96 $27.20 10%
4 6X4 TEE L/A $43.77 $177.60 $39.40 $17.48 10%

SUBTOTAL $449.60 $44.68
10%

Thanks!