I need to validate the po number from invoice againest the po excel file. if in case any po number mathces i need validate remaining cloumn in po excel sheet with the invoice excel
ie., Po number == po number
quantiy == quantity
if every thing mathces i need to write a matched date into separate excel file
If possible could you share the Input excel file and Expected output file.
here input sheets are:
Invoice.xlsx (8.8 KB)
Purchase order Reference.xlsx (9.8 KB)
Custom Document.xlsx (9.2 KB)
three files am having i need to validate in the sence like if po number matches and quantity, unit, like wise i need to matches some fileds with invoice and po againest from invoice and po sheet then i need write that data into another sheet called output sheet.
Hie @Naveen_Kanike if i"m not wrong you suppossed to compare between two excel sheets and if the both sheets column data match you want to write that data into the other excel ?? right…
so for this use 2 read range activity and save there output as dt1 and dt2
and use 2 for each row and inside the use if condition and pass currentrow1("po number).tostring = currentrow2(ponumber).tostring if this true inside that use write cell activity and pass the value and counter the column so you can write next data into the other row …
cheers Happy Automation 
yes but can show me screenshots if possible how to do this for each row activity is not availble for me ?
Here’s @Naveen_Kanike this is Dummy logic you can use to check
cheers happy automation.
Hey @Naveen_Kanike
Your first excel is Invoice and second excel is PO right. After comparing it how you are writing your output excel. If your output excel is Custome Document.xlsx it was very different. Could you be more specific.
custom document is third sheet i need to read here i need to validate 3 sheets for in if i want validate the currentrow(“po”).tostring = currentrow(“po”).tosting for in case here in my excel sheet i want validate the so many cloumn names same like about synax in that case to do that
Do you want to compare three excel files or two excel files… @Naveen_Kanike
what data you want to check means which columns…?
If the data matches where you want to write the data and what data you want to write…?
i want to compare 3 excel files and i want check po number, ksn code,quantity, unit price,currency, gross value, total, aditional cost from invoice and po excel files and from custom to invoice i want match these cloumns hs code only? and macthed data i need to store it another excel sheet with all the po number qunatity, unit, total price, hs code, current etc which is all matching data.
iam not able write the data into write range workbook? after using filter date table
getting any error… @Naveen_Kanike
or writing the empty rows in the excel.
i am getting errors after writing the conditions write range is not writing any thing except the header names