Macro: copy the value of Sheet2 to Sheet1 based on EmployeeID

[jekjhatz]

Hi Guys,

Hope you can help me with this macro.
So I got thousand of employee and I have 2 sheets. Sheet1(for payroll) and Sheet2 (for reporting).
I need to transfer the Sheet2.Salary to Sheet1.Salary with the Sheet1.EmpID criteria.
95% of EmpID exist on the both Sheets. Some of the EMpID only exist to 1 Sheet only due to the employee take their vacation leave.

Thanks for your help in advance.

Sheet1		Sheet2
Col A	Col B		Col D	Col E
EmpID	Salary		EmpID	Salary
0001			0012	20000
0002			0016	29999
0012			0092	29705
0016			0089	4295
0018			0536	19999
0019			0370	4000
			0001	929
			0002	4200
			0018	5266
			0019	1724

<tbody>
</tbody>

 

[alansidman]

suggest you use the Vlookup function

https://www.techonthenet.com/excel/formulas/vlookup.php