Hello, I have looked on the forum but cannot solve this problem. I have two very large data sets I need to compare in an efficient way. My plan is to create two data tables DT1 (original data ) and DT2 (results data ). These will be formatted the same way and basically I want to search with datatable 1 row for a match in data table 2. If no match is found for the row I want the values written in DT3 and exported to excel.
I have done a lot of searching but cannot find a solid solution. Attached is an example of the data columns and the results on DT3 for a non match. Data in all columns needs to match, Basically I am try to sniff out if any data was transferred incorrectly.
I know how to get the DTs up and just need help with the script to search for the entire row. I feel like creating varibles for each column item will take forever and am trying to find a more efficient route.
Thanks Example.xlsx (9.8 KB)