Compare Two Excel FilesFile 1: Invoice_Jan.xlsxFile 2: Invoice_Feb.xlsxBoth contain:Invoice_No Vendor Amount INV001 ABC Corp 1000 INV002 XYZ Pvt 2000 INV003 LMN Ltd 1500 Invoice_No Vendor Amount INV001 ABC Corp 1000 INV002 XYZ Pvt 2100 INV003 LMN Ltd 1500 👉 Compare Invoice_No and Amount —if mismatch or missing, log invoice_no vendor amount details to Mismatched_Invoices.xlsx

compare two excel files and update the mismatch data in another workbook

Compare Two Excel Files

File 1: Invoice_Jan.xlsx
File 2: Invoice_Feb.xlsx

Both contain:

👉 Compare Invoice_No and Amount —
if mismatch or missing, log invoice_no vendor amount details to Mismatched_Invoices.xlsx

Page 1 / 1

Hi @rishav_anand,

Could you please be more specific on what exactly your issue is? Or do you need a step-by-step approach to automate this process?