How to write the macro for not match two excel sheet

L

Lillian Lian

I have one excel spreed that has sheet1 and sheet2, both has same like this
ColumnA ColumnB ColumnC ColumnC
name SSN domain users

sheet1 has 947 records
sheet2 has 1142 records
I would like match SSN on columnB,
if they are match then move all the name, SSN, domain, users to sheet3.
if they are not match then write all the name, SSN, domain, users to sheet4

thanks for all the help

Lillian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two excel spread sheet with macro 5
Match two excel spread sheet using Macro 3
match two excel spread sheet using macro 11
Excel Macro for match name 5
Only matach two excel spread sheet 2
Excel Macro using vb script 2
Created another spread sheet if SSN is not match 3
Match excel spread sheet with macro 2

Top