Excel - VB code to summarise a series of values

By timmy1982
Dec 6, 2007
  1. Hello there,

    I have been given a work sheet with a series of values which I have attached (not the real names).

    I am to group all of the 'Element Names' (for each person) under the same values, adding together the arrears, e.g.

    In the eaxample I have attached, Brett Smith has 4 element types (Acting Up Hours Non Pens, OT @ 1 Non Pens, OT @ 1.5 Non Pens, OT @ 2 Non Pens). These have a series of arrear amounts. I wish to run a script which will output 4 Brett Smith Rows, with each element and the total of arrears.

    I am relatively new to VB coding, particularly in Excel so please be gentle :) .

    Any help would be greatly appreciated.
  2. timmy1982

    timmy1982 TS Rookie Topic Starter


    No worries, I've imported the table into access and run a query. Using the Group By function I was able to summarise the data.


Topic Status:
Not open for further replies.

Similar Topics

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...