Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    47

    Unanswered: Subtotals by Group

    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

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •