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)

Hi @mohammed_zain.

Can you share excel file?

Thanks

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

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)