Subtotals macro

[Sami82]

Hi All,

Ok, I have users type in the data in a form and it fills in the report
(attached) like so:

code value gst value
prod1 $1,000.00 $100.00 $1,100.00
prod1 $1,000.00 $100.00 $1,100.00
prod2 $1,000.00 $100.00 $1,100.00
prod3 $1,000.00 $100.00 $1,100.00

I want it to separate the different products (after the form has been
completed) making a subtotal line and then following a blank one after,
such as:

code value gst value
prod1 $1,000.00 $100.00 $1,100.00
prod1 $1,000.00 $100.00 $1,100.00
$2,000.00 $200.00 $2,100.00

prod2 $1,000.00 $100.00 $1,100.00
$1,000.00 $100.00 $1,100.00

prod3 $1,000.00 $100.00 $1,100.00
$1,000.00 $100.00 $1,100.00

The only problem is that the amount of entries for a product will
always change so i cant put static formulas in. Please see my example
attachment for further understanding.

Thank you
Sam


+-------------------------------------------------------------------+
|Filename: summary total macro.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3804 |
+-------------------------------------------------------------------+

 

[Gary Keramidas]

the easiest way is to select all of the columns, click data/subtotals and
select at each change is code and select sum of the columns you want
you can record a macro while you do this, too.

 

[Sami82]

Worked a charm!

Just wondering if it is possible to set the format to leave a space
below the subtotal and draw boarders?

Thanks