split up data and total for summary report

[t0aster_uk]

Hi,

I'm trying to create a summary sheet for some data, here is an example:

Book1
	A	B	C	D	E
1	Customer		Quanity Ordered	unit price	Total cost
2	customerA		5	0.23	1.15
3	customerA		13	1.99	25.87
4	CustomerB		24	3.49	83.76
5	CustomerB		3	1.25	3.75
6	CustomerB		4	2.5	10
7	CustomerC		9	7.99	71.91
Sheet1

what i would like to do is add blank lines between each customer and add a sub total and a total at the end ie:

Book1
	A	B	C	D	E
1	Customer		Quanity Ordered	unit price	Total cost
2	customerA		5	0.23	1.15
3	customerA		13	1.99	25.87
4	subtotal		18		27.02
5
6	CustomerB		24	3.49	83.76
7	CustomerB		3	1.25	3.75
8	CustomerB		4	2.5	10
9	subtotal		31		97.51
10
11	CustomerC		9	7.99	71.91
12	subtotal		9		71.91
13
14	TOTAL		58		196.44
Sheet1

Is there an easy-ish way to do this? go gentle on me I'm pretty new to the world of VBA!

Cheers in advance t0aster

 

[cherria]

Select Data->Subtotal and Excel will do it automatically for you once you select a few options

 

[t0aster_uk]

Cheers for that!

is there a simple way of calling this from a macro? i'm sorting out the workbook for someone who has even less of a clue than me and it would be nice to hide any scary dialog boxes from them!!

T0aster

 

[cherria]

Yes it is possible, why don't you record the actions you take to subtotal and see what you get in the recorded macro. This will give you a good start.