Compare the values of two worksheets [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,



I want to compare the values of two worksheets say sheet1 and sheet2 (col1) and want to add all the values col2 of both sheets in another sheet say sheet3.

Kindly get me the code.

1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi tkp123,

Could you give a small example of your data on all 3 sheets for better understanding.

Like this:
Sheet1
abc 3
def 5

Sheet 2
jkl 9
def 4

Sheet 3
abc 3
def 9 'added both sheets because of match
def 4

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!