Match /Vlookup/ Manipulate data base on Criteria

Status
Not open for further replies.

JackMouct

New Member
Joined
Dec 26, 2016
Messages
3
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.



 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

cchavez24

New Member
Joined
Dec 28, 2016
Messages
42
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

New Member
Joined
Dec 26, 2016
Messages
3
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
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,122,575
Messages
5,596,955
Members
414,114
Latest member
Lost_User21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top