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.