Report

Macro for comparing values in 2 columns of separate worksheets

Ask a question MadhaviLakshmi 2Posts Monday October 9, 2017Registration date October 10, 2017 Last seen
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

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!