Macro to match two sets of data [Closed]

Nick - Jul 26, 2016 at 10:22 AM - Latest reply: xpcman 18932 Posts Wednesday October 8, 2008Registration dateModeratorStatus May 22, 2018 Last seen
- Jul 26, 2016 at 12:57 PM
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.
See more 

1 reply

xpcman 18932 Posts Wednesday October 8, 2008Registration dateModeratorStatus May 22, 2018 Last seen - Jul 26, 2016 at 12:57 PM
0
Helpful
Are you using EXCEL or some MAC program?