I have been working to compare two workbooks inside of the same excel file. I have been stuck and cannot seem to fix my problem. My application is enclosed in this ticket, if someone could help with a correction I would greatly appreciate it.
I am looking to confirm that 5 values match in both workbooks, if so I would like “Pass” to be written at the end of the row in excel (Column S). If the records do not match I would like “Fail” to be written at the end of the row.
The system will only write the first row and is writing fail although it should be pass
I can get the application to run when searching for just one value but when I add the other 4 I receive an error “The source contains no data” I assume this means that there is blank data in one of the cells?
If someone could help me with this I would greatly appreciate
Validation.xaml (10.5 KB) it.