t0aster_uk
New Member
- Joined
- Dec 23, 2004
- Messages
- 6
Hi,
I'm trying to create a summary sheet for some data, here is an example:
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:
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
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