Macro to match two sets of data [Closed]

Report
-
Posts
19674
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
Hello All
I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on sheet3.

My headings will always be the same between sheet1 and sheet2 but the information may vary.
for information purposes, i included the headings.

ID Number Payroll Number SURNAME First Name Salary Date of Birth Member Group

I am struggling with this. So please extend your helping hands
Thank you.

1 reply

Posts
19674
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
6,287
Are you using EXCEL or some MAC program?