Macro for comparing values in 2 columns of separate worksheets

MadhaviLakshmi 2 Posts Monday October 9, 2017Registration date October 10, 2017 Last seen - Oct 10, 2017 at 12:36 AM
I need to write a macro that do the following. Please help me in this

Basically need to compare data in 2 worksheets

e.g: AccountId Account Number Membership Tier Engagement Tier Status Date Membership Program Geo Market Code
63467 2000 GOLD 1/9/2013 ITP EMEA EMAR
193015 2001 GOLD 1/8/2013 ITP EMEA MATURE
97022 2002 GOLD 1/10/2013 ITP ASMO-LAR EMAR
209748 2003 REGISTERED 9/3/2015 ITP APAC EMAR
91382 2004 REGISTERED 6/4/2010 ITP ASMO-NA MATURE




If cell A1 in worksheet 1 = A1 in work sheet 2
similarly check if B1 = B1 & C1 = C1 & D1 = D1.
If all match then post "Matched" to seperate worksheet 3, else post "Not matched to sep worksheet3

I have columns from "A" to "AE" to compare
See more