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...