Hi Everyone, Please find attached data and i am trying to create code that will do exactly in example in data attached. All i want in here is if employee pay pension contributions for 100 (Pen EE (Tal)) and employer pay for 200 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)

I hope this makes sense. i have tried several method for the pass 8 hrs but nothing. Thank you all for your help. Please see below attached

Data Download.xlsm