Report

Macro to match two sets of data [Closed]

Ask a question Nick - Last answered on Jul 26, 2016 at 12:57 PM by xpcman
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 
Helpful
+0
plus moins
Are you using EXCEL or some MAC program?

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!