Hi Everyone, Please find attached data and i am trying to create code that will do exactly as an example tab (sheet 3) in data attached. All i want is to pull for one part and then second part value to match the same emplyee. In other words, if employee pay pension contributions for 100 (Pen EE (Tal)) and employer pay for 200 (Pen ERS (Tal)) on behalf of the same employee. Then, the worksheet should look like Colunm A= Pers No, Column B=Employee Name, Colunm C= ID Number, Column D=PenPay, Column E=Pens EE(Tal) and Column F=Pens ER(Tal) and G= Total (Pen EE +Pen ER values), as exactly in example tab.

I hope this makes sense. i have tried several methods but no luck far. Thank you all for your help. Please find attached


Data Download.xlsm