Excel - VB code to summarise a series of values

[timmy1982]

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.

 

[timmy1982]

Done

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.

Thanks

tim