Hi Group,
I have an Excel template which will be populated dynamically with data from my .ASP Page.

The format of the template is as follows:

Column B: Branch
Column C: Account No
Column E: Turnover

At the moment, I have a grand total but will need to have subtotals for each Branch.
How can I achieve this using VBA

Kind regards
Jackie

Example is as follows:
Branch Account No Turnover
Cambridge 1 50.00
Cambridge 2 48.00
Cambridge 3 15.00
Harlow 1617 25.00
Harlow 4556 45.00

Totals: 183.00


I need the report to look like this
Branch Account No Turnover
Cambridge 1 50.00
Cambridge 2 48.00
Cambridge 3 15.00
Total 113.00

Harlow 1617 25.00
Harlow 4556 45.00
Total 70.00

Totals: 183.00

Unless I'm misunderstanding, there's no need for VBA.

Goto Data-->Subtotals and Subtotal on Branch Name.

If you need that in VBA, just record it and it will give you what you need.

Hope that helps,

Smitty