Compare two excels(Book1 and Book2)

Learn Academy Feedback
, ,
1

I want to compare two excels(Book1 and Book2). how to check if value is there in another excel if value is not there then it should write in another excel. Pls help me in this. Thanks.
BlankProcess11.zip (15.0 KB)

2

Hi @mohammed_zain.

Can you share excel file?

Thanks

3

Book1.xlsx (8.6 KB) Book2.xlsx (8.5 KB)

4

1)Read range -----Book1-----OUPUT-Book1
2)Read range-----Book2------OUTPUT-Book2
3)For each row1_Book2 in Book2
For each row2_book1 in Book1

if
cint(row1_Book2.Item(“Company Name”)) = cint(row2_book1 .Item(“Company Name”))
Assign :
i = (Book2.Rows.IndexOf( row2_book1 )+1)

writecell :
Range : “D” &I+1
IMPUT:row1_Book2(1).ToString

ELSE PART

Assign :
j = (Book2.Rows.IndexOf( row2_book1 )+1)

writecell :
Range : “D” &j+1
IMPUT:“nOT AVIALABLE”

Book1.xlsx (8.6 KB) Book2.xlsx (9.4 KB)