Match /Vlookup/ Manipulate data base on Criteria

[JackMouct]

Hi Everyone, I am trying to create code that will help me achieve the correct format. All i want is to pull employee (EE) entire row and pates into new sheet and and then second part (ER) 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.

 

[cchavez24]

Can you show us how you have the raw data layed out? Is the employer compansation automatic so it can be calculated?

I am leaning towards pivot tables.

 

[JackMouct]

Hi, Thank you for your respond. Please see below as requested.

A B C D E F
Pers.No Name ID Number Pension Type Pensionable Pay Amount Net Amount
008835 Jack Wilson NE54315 Pens EE(Tal) 827.57 45.52
008835 Jack Wilson NE54315 Pens ER(Tal) 827.57 162.20

I need to a code that can do below example lay out. I am fairly new on VBA coding

A B C D E F G
Pers.No Name ID Number Pensionable Pay Amount Pens EE(Tal) Pens ER(Tal) Total
008835 Jack Wilson NE54315 827.57 45.52 162.20 207.72 (45.52+162.20)

Thank you again for you help

 

[Zack Barresse]

Cross-posted:

Match and Vlookup method
Consolidate and add value in next Row

@JackMouct: please read: Excelguru Help Site - A message to forum cross posters